Data Warehousing Question:
Download Questions PDF

What is the function of Optimizer?

Data Warehousing Interview Question
Data Warehousing Interview Question

Answer:

The goal of the optimizer is to choose the most efficient way to execute a SQL statement.

Download Data Warehousing Interview Questions And Answers PDF

Previous QuestionNext Question
What is the effect of setting the value "CHOOSE" for OPTIMIZER_GOAL, parameter of the ALTER SESSION Command?What is Execution Plan?