What is the function of Optimizer ?

Answer Posted / guest

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

Is This Answer Correct ?    4 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain about the analyze command in oracle?

593


WHAT IS THE DEFINITION OF DEFAULT CUSTOMER IN AR?

1705


How to load a large xml file?

587


How to see the table columns used in an index?

600


How to synchronize 2 schema's objects?

1692






How to use null as conditions in oracle?

584


State and explain the different types of data models?

538


How to speed up webrick?

603


How to convert character types to numeric types?

582


Explain drop constraint oracle?

595


Why we use bulk collect in oracle?

541


What is a dynamic performance view in oracle?

608


How to join two tables in a single query using oracle?

568


What are the components of logical database structure in oracle database?

585


How to define a procedure inside another procedure?

551