Table 3 Synthetic 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 |
903 | 4097 | 2457 | 2543 | 3958 | 1042 | 4730 | 270 | 4956 | 44 | |
99% Q-error | 3.3 | 59.0 | 9.4 | 90.8 | 16.8 | 170.1 | 43.4 | 292.5 | 54.9 | 157.2 |