Planner — SQL Server — TPC-H
Summary — Comparing other engines
Scan Scan | Join Probe Join | Sort Sort | Hash Build Hash | Aggregate Agg | Distribute Dist | |
|---|---|---|---|---|---|---|
 ClickHouse | Estimation Error Est Err Row Operations Ops 79,980,863 80M Rank | Estimation Error Est Err Row Operations Ops 70,658,594 71M Rank | Estimation Error Est Err Row Operations Ops 126,418 126K Rank | Estimation Error Est Err Row Operations Ops 48,026,205 48M Rank | Estimation Error Est Err Row Operations Ops 16,302,272 16M Rank | Estimation Error Est Err Row Operations Ops 0 0 Rank |
 DuckDB | Estimation Error Est Err Row Operations Ops 89,761,923 90M Rank | Estimation Error Est Err Row Operations Ops 68,830,910 69M Rank | Estimation Error Est Err Row Operations Ops 49,283 49K Rank | Estimation Error Est Err Row Operations Ops 7,632,898 7.6M Rank | Estimation Error Est Err Row Operations Ops 14,294,766 14M Rank | Estimation Error Est Err Row Operations Ops 0 0 Rank |
 PostgreSQL | Estimation Error Est Err Row Operations Ops 65,389,535 65M Rank | Estimation Error Est Err Row Operations Ops 43,174,275 43M Rank | Estimation Error Est Err Row Operations Ops 14,013,796 14M Rank | Estimation Error Est Err Row Operations Ops 16,047,732 16M Rank | Estimation Error Est Err Row Operations Ops 16,814,950 17M Rank | Estimation Error Est Err Row Operations Ops 0 0 Rank |
 SQL Server | Estimation Error Est Err Row Operations Ops 75,791,798 76M Rank | Estimation Error Est Err Row Operations Ops 59,322,313 59M Rank | Estimation Error Est Err Row Operations Ops 509,763 510K Rank | Estimation Error Est Err Row Operations Ops 6,653,004 6.7M Rank | Estimation Error Est Err Row Operations Ops 14,289,817 14M Rank | Estimation Error Est Err Row Operations Ops 0 0 Rank |
TPC-H — Full compare
Breakdown — TPC-H — SQL Server
Scan Scan | Join Probe Join | Sort Sort | Hash Build Hash | Aggregate Agg | Distribute Dist | |
|---|---|---|---|---|---|---|
| TPCH-Q01 | Estimation Error Est Err Row Operations Ops 5,642,532 5.6M Rank | Estimation Error Est Err Row Operations Ops 0 0 Rank | Estimation Error Est Err Row Operations Ops 4 4 Rank | Estimation Error Est Err Row Operations Ops 0 0 Rank | Estimation Error Est Err Row Operations Ops 5,642,532 5.6M Rank | Estimation Error Est Err Row Operations Ops 0 0 Rank |
| TPCH-Q02 | Estimation Error Est Err Row Operations Ops 610,825 611K Rank | Estimation Error Est Err Row Operations Ops 614,728 615K Rank | Estimation Error Est Err Row Operations Ops 819 819 Rank | Estimation Error Est Err Row Operations Ops 7,565 7.6K Rank | Estimation Error Est Err Row Operations Ops 473 473 Rank | Estimation Error Est Err Row Operations Ops 0 0 Rank |
| TPCH-Q03 | Estimation Error Est Err Row Operations Ops 4,111,171 4.1M Rank | Estimation Error Est Err Row Operations Ops 4,080,935 4.1M Rank | Estimation Error Est Err Row Operations Ops 10 10 Rank | Estimation Error Est Err Row Operations Ops 276,724 277K Rank | Estimation Error Est Err Row Operations Ops 28,114 28K Rank | Estimation Error Est Err Row Operations Ops 0 0 Rank |
| TPCH-Q04 | Estimation Error Est Err Row Operations Ops 3,843,515 3.8M Rank | Estimation Error Est Err Row Operations Ops 3,791,311 3.8M Rank | Estimation Error Est Err Row Operations Ops 5 5 Rank | Estimation Error Est Err Row Operations Ops 52,204 52K Rank | Estimation Error Est Err Row Operations Ops 47,831 48K Rank | Estimation Error Est Err Row Operations Ops 0 0 Rank |
| TPCH-Q05 | Estimation Error Est Err Row Operations Ops 6,372,867 6.4M Rank | Estimation Error Est Err Row Operations Ops 6,533,953 6.5M Rank | Estimation Error Est Err Row Operations Ops 5 5 Rank | Estimation Error Est Err Row Operations Ops 254,041 254K Rank | Estimation Error Est Err Row Operations Ops 6,988 7K Rank | Estimation Error Est Err Row Operations Ops 0 0 Rank |
| TPCH-Q06 | Estimation Error Est Err Row Operations Ops 121,014 121K Rank | Estimation Error Est Err Row Operations Ops 0 0 Rank | Estimation Error Est Err Row Operations Ops 0 0 Rank | Estimation Error Est Err Row Operations Ops 0 0 Rank | Estimation Error Est Err Row Operations Ops 121,014 121K Rank | Estimation Error Est Err Row Operations Ops 0 0 Rank |
| TPCH-Q07 | Estimation Error Est Err Row Operations Ops 3,375,139 3.4M Rank | Estimation Error Est Err Row Operations Ops 2,009,308 2M Rank | Estimation Error Est Err Row Operations Ops 134,162 134K Rank | Estimation Error Est Err Row Operations Ops 1,769,090 1.8M Rank | Estimation Error Est Err Row Operations Ops 5,457 5.5K Rank | Estimation Error Est Err Row Operations Ops 0 0 Rank |
| TPCH-Q08 | Estimation Error Est Err Row Operations Ops 6,588,582 6.6M Rank | Estimation Error Est Err Row Operations Ops 6,079,412 6.1M Rank | Estimation Error Est Err Row Operations Ops 54,959 55K Rank | Estimation Error Est Err Row Operations Ops 645,629 646K Rank | Estimation Error Est Err Row Operations Ops 2,323 2.3K Rank | Estimation Error Est Err Row Operations Ops 0 0 Rank |
| TPCH-Q09 | Estimation Error Est Err Row Operations Ops 8,119,783 8.1M Rank | Estimation Error Est Err Row Operations Ops 7,090,006 7.1M Rank | Estimation Error Est Err Row Operations Ops 245,841 246K Rank | Estimation Error Est Err Row Operations Ops 2,023,977 2M Rank | Estimation Error Est Err Row Operations Ops 245,666 246K Rank | Estimation Error Est Err Row Operations Ops 0 0 Rank |
| TPCH-Q10 | Estimation Error Est Err Row Operations Ops 1,596,844 1.6M Rank | Estimation Error Est Err Row Operations Ops 1,572,918 1.6M Rank | Estimation Error Est Err Row Operations Ops 30,170 30K Rank | Estimation Error Est Err Row Operations Ops 168,665 169K Rank | Estimation Error Est Err Row Operations Ops 108,325 108K Rank | Estimation Error Est Err Row Operations Ops 0 0 Rank |
| TPCH-Q11 | Estimation Error Est Err Row Operations Ops 1,220,002 1.2M Rank | Estimation Error Est Err Row Operations Ops 1,222,806 1.2M Rank | Estimation Error Est Err Row Operations Ops 2,806 2.8K Rank | Estimation Error Est Err Row Operations Ops 66,314 66K Rank | Estimation Error Est Err Row Operations Ops 44,516 45K Rank | Estimation Error Est Err Row Operations Ops 0 0 Rank |
| TPCH-Q12 | Estimation Error Est Err Row Operations Ops 1,529,129 1.5M Rank | Estimation Error Est Err Row Operations Ops 1,500,000 1.5M Rank | Estimation Error Est Err Row Operations Ops 2 2 Rank | Estimation Error Est Err Row Operations Ops 29,129 29K Rank | Estimation Error Est Err Row Operations Ops 29,129 29K Rank | Estimation Error Est Err Row Operations Ops 0 0 Rank |
| TPCH-Q13 | Estimation Error Est Err Row Operations Ops 1,649,945 1.6M Rank | Estimation Error Est Err Row Operations Ops 150,000 150K Rank | Estimation Error Est Err Row Operations Ops 48 48 Rank | Estimation Error Est Err Row Operations Ops 150,000 150K Rank | Estimation Error Est Err Row Operations Ops 1,649,945 1.6M Rank | Estimation Error Est Err Row Operations Ops 0 0 Rank |
| TPCH-Q14 | Estimation Error Est Err Row Operations Ops 268,122 268K Rank | Estimation Error Est Err Row Operations Ops 200,000 200K Rank | Estimation Error Est Err Row Operations Ops 0 0 Rank | Estimation Error Est Err Row Operations Ops 68,122 68K Rank | Estimation Error Est Err Row Operations Ops 68,122 68K Rank | Estimation Error Est Err Row Operations Ops 0 0 Rank |
| TPCH-Q15 | Estimation Error Est Err Row Operations Ops 268,122 268K Rank | Estimation Error Est Err Row Operations Ops 200,000 200K Rank | Estimation Error Est Err Row Operations Ops 0 0 Rank | Estimation Error Est Err Row Operations Ops 68,122 68K Rank | Estimation Error Est Err Row Operations Ops 68,122 68K Rank | Estimation Error Est Err Row Operations Ops 0 0 Rank |
| TPCH-Q16 | Estimation Error Est Err Row Operations Ops 722,464 722K Rank | Estimation Error Est Err Row Operations Ops 778,800 779K Rank | Estimation Error Est Err Row Operations Ops 15,163 15K Rank | Estimation Error Est Err Row Operations Ops 240,014 240K Rank | Estimation Error Est Err Row Operations Ops 122,417 122K Rank | Estimation Error Est Err Row Operations Ops 0 0 Rank |
| TPCH-Q17 | Estimation Error Est Err Row Operations Ops 12,363 12K Rank | Estimation Error Est Err Row Operations Ops 928 928 Rank | Estimation Error Est Err Row Operations Ops 0 0 Rank | Estimation Error Est Err Row Operations Ops 6,544 6.5K Rank | Estimation Error Est Err Row Operations Ops 6,544 6.5K Rank | Estimation Error Est Err Row Operations Ops 0 0 Rank |
| TPCH-Q18 | Estimation Error Est Err Row Operations Ops 11,997,650 12M Rank | Estimation Error Est Err Row Operations Ops 5,998,830 6M Rank | Estimation Error Est Err Row Operations Ops 5 5 Rank | Estimation Error Est Err Row Operations Ops 45 45 Rank | Estimation Error Est Err Row Operations Ops 5,998,855 6M Rank | Estimation Error Est Err Row Operations Ops 0 0 Rank |
| TPCH-Q19 | Estimation Error Est Err Row Operations Ops 331,301 331K Rank | Estimation Error Est Err Row Operations Ops 131,301 131K Rank | Estimation Error Est Err Row Operations Ops 0 0 Rank | Estimation Error Est Err Row Operations Ops 200,000 200K Rank | Estimation Error Est Err Row Operations Ops 97 97 Rank | Estimation Error Est Err Row Operations Ops 0 0 Rank |
| TPCH-Q20 | Estimation Error Est Err Row Operations Ops 1,466,333 1.5M Rank | Estimation Error Est Err Row Operations Ops 1,481,552 1.5M Rank | Estimation Error Est Err Row Operations Ops 25,361 25K Rank | Estimation Error Est Err Row Operations Ops 49,100 49K Rank | Estimation Error Est Err Row Operations Ops 40,470 40K Rank | Estimation Error Est Err Row Operations Ops 0 0 Rank |
| TPCH-Q21 | Estimation Error Est Err Row Operations Ops 14,367,119 14M Rank | Estimation Error Est Err Row Operations Ops 14,367,118 14M Rank | Estimation Error Est Err Row Operations Ops 396 396 Rank | Estimation Error Est Err Row Operations Ops 518,976 519K Rank | Estimation Error Est Err Row Operations Ops 4,060 4.1K Rank | Estimation Error Est Err Row Operations Ops 0 0 Rank |
| TPCH-Q22 | Estimation Error Est Err Row Operations Ops 1,576,976 1.6M Rank | Estimation Error Est Err Row Operations Ops 1,518,407 1.5M Rank | Estimation Error Est Err Row Operations Ops 7 7 Rank | Estimation Error Est Err Row Operations Ops 58,743 59K Rank | Estimation Error Est Err Row Operations Ops 48,817 49K Rank | Estimation Error Est Err Row Operations Ops 0 0 Rank |