DEVFYI - Developer Resource - FYI

What is COST-based approach to optimization ?

ORACLE Interview Questions and Answers (Part 1)


(Continued from previous question...)

57. What is COST-based approach to optimization ?

Considering available access paths and determining the most efficient execution plan based on statistics in the data dictionary for the tables accessed by the statement and their associated clusters and indexes.

(Continued on next question...)

Other Interview Questions