A METHOD OF OPTIMIZING SQL QUERY AND OPTIMIZER

摘要

extracting one or more bind values from an inputted SQL query statement; calculating selectivity and correlation coefficient for the bind values; acquiring an execution plan based on the selectivity and the correlation coefficient. Through the embodiments of the present invention, the SQL query can be optimized to a higher degree and the overall query execution time can be reduced.