What are the different approaches used by Optimizer in choosing an execution p

What are the different approaches used by Optimizer in
choosing an execution plan ?

Question Posted / guest

Answers were Sorted based on User's Feedback

What are the different approaches used by Optimizer in choosing an execution plan ?..

Answer / guest

Rule-based and Cost-based

Is This Answer Correct ?

2 Yes

0 No

What are the different approaches used by Optimizer in choosing an execution plan ?..

Answer / nishi

Rule-based and Cost-based.

Is This Answer Correct ?

1 Yes

0 No

More Oracle General Interview Questions

If any one has information regarding interview of NIC (National Informatics Centre),it would be of great help...

How to loop through data rows in the implicit cursor?

How to call a stored function in oracle?

How to drop an existing view in oracle?

It's Urgent? How to IMPORT .xls & .txt file into ORACLE?

What happens internally when the user types userID/password@string in SQL PLUS Thanks-Bhaskar

Explain enable novalidate constraint.

What is the max number of columns in an oracle table?

How to drop a stored procedure in oracle?

In what script is snap$ created? In what script is the scott/tiger schema created?

Does oracle database need java?

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

For more Oracle General Interview Questions Click Here