Rule-based and Cost-based.

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

Question Posted / nishi

Answer Posted / nishi

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What types of joins are used in writing subqueries?

982

How to delete a column in an existing table in oracle?

1071

How to insert a record into a table?

1068

How to open and close an explicit cursor in oracle?

1058

For a field in a repeating frame, can the source come from the column which does not exist in the data group which forms the base for the frame ?

2025

How to bring a tablespace offline?

1064

What is the simplest tool to run commands on oracle servers?

1009

Explain the importance of .pll extension in oracle?

1009

How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?

1915

How to run the anonymous block again?

1130

How to upsert (update or insert into a table)?

999

How to use subqueries in the from clause in oracle?

1111

How to do paging with oracle?

995

Write a trigger example in oracle?

1061

What is a parameter file in oracle?

1134