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

What are the uses of synonyms?

how may join possible between (requisition with purchase order)

How to connect to a remote server?

What the is the diff between local index and global index. give some example.

interview questions with answer for cts

IS it possible to built the oracle database without setting the kernal parameters?

How a database is related to tablespaces?

what is unique key?

how to hide the stored procedure inside a package

select statement does not retrieve any records. what exception is raised?

1.how to extract the second highest salary from emp table having sal as a column which contains the salary of all employee of an organisation.

how can db_files > maxdatafiles since db_files is for instance and the later is for database

For more Oracle General Interview Questions Click Here