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 the use of parfile option in exp command.

773


If youre unsure in which script a sys or system-owned object is created, but you know its in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?

1897


What happens if you lost a data file?

822


What is a snapshot in oracle database?

801


What is the Tune Query

2084


How to create a new table in your schema?

831


Explain oracle instance.

922


What are joins, explain all types of joins?

1964


How to bring a tablespace offline?

770


What is the minimum client footprint required to connect c# to an oracle database?

800


How to drop an existing view in oracle?

764


What is oracle rownum?

720


How to list all user accounts in oracle?

825


What do you mean by group by clause?

800


What is a snapshot log?

784