Firebolt scans, filters, and analyzes data using specialized indexes. The sparse index allows queries to pick up highly granular data ranges without having to scan entire partitions.
Advanced history-based query optimization and JOIN acceleration for extremely fast and cost-efficient JOINs.
Precomputed versions of your data maintained by Firebolt from the base table are leveraged to accelerate queries with aggregate functions.
Firebolt’s query optimizer turns any SQL into its most performant version, taking into account factors like index utilization, JOIN strategies, and data distribution.