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

how to hide the stored procedure inside a package

How to use an explicit cursor without open statements?

how will I find the first 5 highest salaried employees in each dept in oracle.

select * from emp what happened internally when we write this query in the sql prompt?

Please explain joins in oracle?

What is tns entry?

How to revoke create session privilege from a user in oracle?

Which Database is the best for the Security issue ? 1. DB2 2.SQL Server 3.MySQL 4.ORACLE

what are views?

definition of cluster and non-clustered index?

What are the uses of linked server and explain it in detail?

Define the terms primary key foreign key and also the difference between primary and the unique key

For more Oracle General Interview Questions Click Here