Table 7 JOB 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 |
16 | 54 | 24 | 46 | 39 | 31 | 65 | 5 | 68 | 2 | |
99% Q-error | 12.7 | 5012.2 | 523.3 | 5162.0 | 475.6 | 5442.9 | 4806.1 | 2194.4 | 4749.9 | 2260.8 |