notesum.ai

Published at December 3

HERO: 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

Arxiv: http://arxiv.org/pdf/2412.02372v1

Refer to caption

Model	Inference Settings	E2E Boost (%) $\uparrow$	E2E Boost (% of Opt.) $\uparrow$	Ex Boost (% of Opt.) $\uparrow$	Timeouts (%) $\downarrow$	Degradations (%) $\downarrow$	Inference (sec) $\downarrow$
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