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

What is the relationship among database, tablespace and data file?

757


How to compare dates in oracle sql?

855


Explain compound trigger in oracle?

773


How view is different from a table?

810


How to select an oracle system id (sid)?

792


How to grant create session privilege to a user in oracle?

783


What do you mean by redo log file mirroring?

752


How many types of tables are there in oracle?

810


What are the restrictions in a oracle read only transaction?

777


What is SQL Tuning Advisor in Oracle?

873


what is a Nested Loop join?

1804


What is a lookup table in oracle?

741


How to get last row id?

748


You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?

1724


Explain what are clusters?

846