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

Can we store pictures in the database and if so, how it can be done?

1024

How does Oracle guarantee data integrity of data changes?

2379

What is open database communication (odbc) in oracle?

996

What do you mean by a database transaction & what all tcl statements are available in oracle?

988

What is index in Oracle?

1063

How to use "out" parameter properly?

1076

Which is faster join or subquery in oracle?

981

What are group functions in oracle?

1033

How to turn on or off recycle bin for the session?

1102

Can you tell me how to add new column in existing views?how?How is possible?

1431

What is Virtual Private Database in Oracle?

1077

How to list all indexes in your schema?

1083

What is oracle join syntax?

991

How to select some rows from a table in oracle?

1068

How to view existing locks on the database?

1045