Learned Query Optimization by Constraint-Based Query Plan Augmentation

Over the last decades, various cost-based optimizers have been proposed to generate optimal plans for SQL queries. These optimizers are key to achieving good performance in database systems and can speed up query execution. Still, they may need enormous expert efforts and perform poorly on complicat...

Full description

Bibliographic Details

Published in:	Mathematics
Main Authors:	Chen Ye, Haoyang Duan, Hua Zhang, Yifan Wu, Guojun Dai
Format:	Article
Language:	English
Published:	MDPI AG 2024-10-01
Subjects:	query optimization query plan augmentation tree convolutional neural network denial constraints
Online Access:	https://www.mdpi.com/2227-7390/12/19/3102