Will the Optimizer always use COST-based approach if
OPTIMIZER_MODE is set to "Cost"?
- 1 Answers
- 3250 Views
- I also Faced
- E-Mail Answers
Answer / 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 |
What is object data modeling?
We are using Oracle apps with XML publisher.In that,we are facing some problems while giving a Footer in RTF Template.While giving a footer in RTF Template it is Visible in all the pages,but after the PDF is getiing generated,the Footer are Visible on alternate pages only (like on first page ,third page) and so on. Please provide the Solution for getting the Footer on all the pages.
How a database is related to tablespaces?
What is an Integrity Constrains ?
How to create an oracle testing table?
How to test null values?
What is the function of Redo Log ?
how can db_files > maxdatafiles since db_files is for instance and the later is for database
What are the commands youd issue to show the explain plan for select
What is SQL access advisor in Oracle?
How you find out version of installed workflow?
How would you best determine why your MVIEW couldnt FAST REFRESH?
Oracle General 
