What is COST-based approach to optimization ?

Answer Posted / mkjmkumar

CBO Evaluates the cost of available execution paths and
selects the execution path that has lowest relative cost.

Is This Answer Correct ?    1 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How can windows applications connect to oracle servers?

524


What are the types of trigger in oracle?

577


What are the attributes of the cursor?

562


What do you know about normalization? Explain in detail?

499


List the parts of a database trigger.

584






Which dictionary tables and/or views would you look at to diagnose a locking issue?

1490


Is rowid unique in oracle?

532


Explain a synonym?

608


How do I decide when to use right joins/left joins or inner joins or how to determine which table is on which side?

548


What are the attributes that are found in a cursor?

652


What is partitioned table in Oracle?

640


What happens to the data files if a tablespace is dropped?

579


What are temporal data types in oracle?

601


How to create a new table by selecting rows from another table?

555


What is an oracle table?

558