Rule-based and Cost-based

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

Question Posted / guest

Answer Posted / guest

Is This Answer Correct ?

2 Yes

0 No

Please Help Members By Posting Answers For Below Questions

15. Display the item_cost and then truncate it to the nearest hundred, ten, unit, tenth and hundredth.

2291

What privilege is needed for a user to query tables in another schema?

973

What are the varoius components of physical database structure of oracle database?

1006

How do I call oracle stored procedures that take no parameters?

1116

Is the After report trigger fired if the report execution fails ?

2915

How do I connect to oracle database?

1119

What is rowid and rownum in oracle?

1011

What are the data types in oracle?

1040

What is a snapshot in oracle database?

1025

What is the fastest query method to fetch data from the table?

1361

Is there any function in oracle similar like group_concat of mysql?

1053

What are the restrictions on external table columns?

1052

What is user managed backup in Oracle?

1142

Explain what are the type of synonyms?

1111

What are the extensions used by oracle reports?

1037