Optimized columnar storage
Sparse indexing for reduced data scans
Vectorized processing and SIMD utilization. For massive throughput at the CPU level
Aggregating & Join indexes for an extra boost
A query optimizer that accelerates even your most complex queries
Query #1
Query #2
Query #3
Query #5
Query #4
62 sec
72 sec
90 sec
60 sec
83 sec
0.16 sec
0.09 sec
1.88 sec
0.01 sec
1.6 sec
Disclaimer - This is not a global benchmark. The results are based on real world queries and run-times as reported by our users over their data cloud vendor, and their equivalent run-times over the same data in Firebolt after tuning and optimization