Table 5 Scale queries accepted and rejected and their Q-errors for each threshold value
From: Robust Cardinality: a novel approach for cardinality prediction in SQL queries
Threshold | 0.1 | 0.2 | 0.3 | 0.4 | 0.5 | |||||
|---|---|---|---|---|---|---|---|---|---|---|
# of queries | Acc | Rej | Acc | Rej | Acc | Rej | Acc | Rej | Acc | Rej |
246 | 253 | 371 | 128 | 437 | 62 | 475 | 24 | 493 | 6 | |
99% Q-error | 27.2 | 976.4 | 119.9 | 1676.0 | 296.4 | 1278.6 | 452.7 | 1664.1 | 525.7 | 1832.3 |