Focusing on the big ticket items that bring your big-O complexity down. This section is all about the shapes of query plans and the power of the query optimiser.
Component — Planner
Query Planner — Leaderboard
The Query plan quality is measured by the amount of operations that the database must perform while executing the plan.
Database Engines are ranked by running individual queries from various datasets. The best scorer for each query and operation gets 5 points, second best: 4, etc... If you are not in the top 5, you get zero points. All scores per query are then added up to form the final score below.
| Rank | Scan Scan | Seek Seek | Join Probe Join | Sort Sort | Hash Build Hash | Aggregate Agg | Distribute Dist |
|---|---|---|---|---|---|---|---|
| 1 |  SQL Server |  PostgreSQL | SQL Server |  Databricks DuckDB | PostgreSQL | SQL Server |  Trino |
| 2 | PostgreSQL | SQL Server | PostgreSQL | Trino | SQL Server | DuckDB | Databricks |
| 3 | Databricks | Trino | SQL Server | DuckDB |  ClickHouse | ||
| 4 | DuckDB | Databricks | ClickHouse | Databricks | PostgreSQL | ||
| 5 | ClickHouse | DuckDB | PostgreSQL | ClickHouse | Trino | ||
| 6 | Trino | ClickHouse | Trino | Databricks |