notesum.ai
Published at December 3HERO: Hint-Based Efficient and Reliable Query Optimizer
cs.DB
cs.AI
cs.LG
H.2.4; I.2.6; I.2.8
Released Date: December 3, 2024
Authors: Sergey Zinchenko, Sergey Iazov

| Model | Inference Settings | E2E Boost (%) | E2E Boost (% of Opt.) | Ex Boost (% of Opt.) | Timeouts (%) | Degradations (%) | Inference (sec) |
| HERO | Local | 64.6 | 98.4 | 98.9 | 0.0 | 0.0 | 26.7 |
| NN | Pruned Local | 56.2 | 85.7 | 94.1 | 0.9 | 2.7 | 58.5 |
| NN | Local | 37.5 | 57.2 | 97.5 | 4.4 | 5.3 | 170.7 |
| NN | Pruned Greedy | 28.7 | 43.7 | 47.0 | 0.0 | 1.8 | 71.5 |
| NN | Greedy | 20.2 | 30.8 | 68.4 | 1.8 | 2.7 | 180.4 |
| NN | Exhaustive | -17.8 | -27.0 | 98.3 | 8.8 | 10.6 | 475.2 |