Data Access Question:
Download Job Interview Questions and Answers PDF
What is COST-based approach to optimization?
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 Question | Next Question |
Explain What does ROLLBACK do? | Explain What are the values that can be specified for OPTIMIZER_GOAL parameter of the ALTER SESSION Command? |