Database execution plan selection method based on robustness perception cost estimation

The invention discloses a database execution plan selection method based on robustness perception cost estimation, and mainly solves the problem that an execution plan selected in the prior art is unstable in long-term execution. According to the implementation scheme, the robustness of an execution...

Full description

Saved in:
Bibliographic Details
Main Authors LI HUI, LIAN ZHIXIANG, TONG HUA, GAO XIYUE
Format Patent
LanguageChinese
English
Published 25.08.2023
Subjects
CALCULATING
COMPUTING
COUNTING
ELECTRIC DIGITAL DATA PROCESSING
PHYSICS
Online AccessGet full text

Cover

More Information
Summary:The invention discloses a database execution plan selection method based on robustness perception cost estimation, and mainly solves the problem that an execution plan selected in the prior art is unstable in long-term execution. According to the implementation scheme, the robustness of an execution plan is quantified by using cardinal number-integral robustness measurement; expanding the single cardinality estimation to cardinality estimation which is uniformly distributed in the range of upper and lower limits [f </= f </= >], performing undifferentiated area integration on the cardinality estimation in the range, and normalizing robustness and estimation cost into a single value; the candidate plans are selected according to the single value, and optimization of the cost model in the optimizer stage is achieved. Compared with the prior art, the method has the advantages that the optimal or nearly optimal query execution plan can be found, double indexes of low plan cost and high robustness are met at the s
Bibliography:Application Number: CN202310624583