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

How to create tables for odbc connection testing?

1001

Differentiate between translate and replace?

1033

How many anonymous blocks can be defined?

1096

What is oracle join syntax?

940

Hi this srilatha. I comlpeted my Oracle-hrms. can u provide me interview questions on Core hr, payroll,sshr,OLM etc..

2066

Explain oracle 12c new features for developers?

992

What to do if dba lost the system password?

1084

What is oracle used for?

966

How to see free space of each tablespace?

966

How to use subqueries with the exists operator in oracle?

967

What is an oracle database table?

958

WHEN CURSOR MOVES FROM ONE FORM TO ANOTHER FORM, HOW MANY TRIGGER WILL BE FIRED AND WHAT ARE THEIR SEQUENCE?

2246

What is the oracle implicit cursor?

994

How to connect the oracle server as sysdba?

1008

Explain an exception and its types?

1008