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

What is the function of Optimizer ?

Question Posted / guest

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

Please Help Members By Posting Answers For Below Questions

How do I find the database name in oracle?

979

What are the built-in functions used for sending Parameters to forms ?

3307

Write a trigger example in oracle?

980

What do you mean by group by clause?

977

What are a query and state the different types of queries and their uses?

940

What is the difference between alert log file and tarce file ?

2096

What is the difference between count (*), count (expression), count (distinct expression)?

964

How many types of database triggers exist?

1063

How to convert numbers to characters in oracle?

967

What is an oracle function?

1071

What is sharded cluster?

924

What is a partition in oracle?

1035

How do we get field details of a table?

931

How to check the server version in oracle?

1032

Explain the different normalization forms?

1008