Table 2 Aggregated Q-error of cardinality estimates of synthetic 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 | 171.120 | 1.775 | 20.352 | 80.000 | 964.000 | 314,187.000 |
MSCN | 7.659 | 2.000 | 9.829 | 20.618 | 77.337 | 6586.000 |
Robust Cardinality | 21.920 | 1.243 | 5.000 | 12.245 | 50.690 | 32,803.500 |