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

What do you understand by a database object?

1061

How to create id with auto_increment on oracle?

990

What is meant by joins? List out the types of joins.

1031

How can we find out the current date and time in oracle?

1088

How to add a new column to an existing table in oracle?

1139

Explain the use of online redo log files in oracle.

1036

What is a cursor and what are the steps need to be taken?

1202

How to pass a parameter to a cursor in oracle?

1178

How to count duplicated values in a column in oracle?

1039

Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com

1865

How to create a stored function in oracle?

1105

Oracle

2375

Can we write insert statement in function in oracle?

1089

How to open and close an explicit cursor in oracle?

1058

Explain enable novalidate constraint.

1080