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 to export your own schema?

585


How many types of auditing in Oracle?

575


What happens in oracle commit?

582


Differentiate between post-database commit and post-form commit?

553


When do you get a .pll extension in oracle? Explain its importance

582






How to retrieve the count of updated rows?

584


What is program global area (pga) in oracle?

613


What is a system tablespace?

616


What is the difference between sharding and replication?

493


Name the three major set of files on disk that compose a database in Oracle?

643


What is an oracle user role?

579


How to add a new column to an existing table with a default value?

559


Explain compound trigger in oracle?

567


How would you begin to troubleshoot an ORA-3113 error?

1612


How to create a new table in oracle?

603