The optimal plans are determined by calculating comprehensively-evaluated values and creating the mathematical expressions of fuzzy subjection degree for diverse quantitative indexes.

However, if literals are important to get optimal access plans, the shorter execution times of the SQL statements are more important than the elegancy of the application's source code.

The optimizer relies on statistics to properly cost alternative query execution plans (QEPs) and choose the most optimal plan.