Data Access Question:

Download Job Interview Questions and Answers PDF

What is COST-based approach to optimization?

Oracle Data Access Interview Question
Oracle Data Access Interview Question

Answer:

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.

Download Oracle Data Access Interview Questions And Answers PDF

Previous QuestionNext Question
Explain What does ROLLBACK do?Explain What are the values that can be specified for OPTIMIZER_GOAL parameter of the ALTER SESSION Command?