Table 6 Aggregated Q-error of cardinality estimates of JOB workload by each model (lower is better)
From: Robust Cardinality: a novel approach for cardinality prediction in SQL queries
Technique | Mean | Median | Percentile | Maximum | ||
|---|---|---|---|---|---|---|
90 | 95 | 99 | ||||
PostgreSQL | 34.411 | 9.841 | 102.475 | 127.213 | 255.637 | 280.122 |
MSCN | 86.983 | 6.622 | 85.548 | 124.868 | 1572.327 | 4506.700 |
Robust Cardinality | 554.055 | 12.368 | 1859.547 | 2874.295 | 4712.486 | 6004.769 |