What is COST-based approach to optimization ?

Answer Posted / tony

Cost Based Optimizer (CBO) - This method is used if
internal statistics are present. The CBO checks several
possible execution plans and selects the one with the
lowest cost, where cost relates to system resources.

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size ?

1883


How to display row numbers with the records?

588


what is IDE,DMV in sql server?

2253


How can I combine multiple rows into a comma-delimited list in oracle?

583


what's query optimization and without use of IN AND Exist can we get another way data from query

1672






What happens if you set the sga too low in oracle?

559


What are set operators?

649


What are the various constraints used in oracle?

556


6. Display the client name and order date for all orders using the traditional method.

1753


How to insert multiple rows with one insert statement in oracle?

573


How to insert a new row into a table in oracle?

593


How to drop an existing table in oracle?

594


can anyody please send me the dump for Oracle 10g certifications for DBA path?

1698


How to connect ms access to oracle servers?

552


How does oracle handle read consistency?

680