1. Categories >> Software >> Databases >> Oracle >> Oracle General
  2. Suggest New Category

Will the Optimizer always use COST-based approach if
OPTIMIZER_MODE is set to "Cost"?

Question Posted / guest

Answer Posted / guest

Presence of statistics in the data dictionary for atleast
one of the tables accessed by the SQL statements is
necessary for the OPTIMIZER to use COST-based approach.
Otherwise OPTIMIZER chooses RULE-based approach.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is procedure overloading in oracle?

546

What is the meaning of recursive hints in oracle?

532

What is the use of aggregate functions in oracle?

581

How to call a stored function in oracle?

574

Hi this srilatha. I comlpeted my Oracle-hrms. can u provide me interview questions on Core hr, payroll,sshr,OLM etc..

1658




What is recovery manager in Oracle?

591

How to create a new view in oracle?

622

Respected sir, Please send me technical questions related to oracle apps..

1381

what is the difference between data migration and production migration.

1813

How to invoke the data pump import utility?

653

What is the implicit cursor in oracle?

570

In SAP ECC 6.0 , under DB02 tcode , Tablespace name to be explain stepy step all the col

3704

What is Virtual Private Database in Oracle?

629

Is truncate autocommit in oracle?

641

Why do we need oracle client?

511