Data Access Question: Download Oracle Data Access PDF

What is COST-based approach to optimization?

Tweet Share WhatsApp

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 PDF Read All 18 Oracle Data Access Questions
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?