Interested to Buy Any Domain ? << Click Here >> for more details...
Will the Optimizer always use COST-based approach if
OPTIMIZER_MODE is set to "Cost"?
- 1 Answers
- 4040 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 |
How can we force the database to use the user specified rollback segment?
what is grid in Oracle 10g...
How to use "out" parameter properly?
Give SQL Query to find the number words in a sentence ? ex: 'ram charan singh' then ans:3
Explain the importance of .pll extension in oracle?
25. Display the client number and the value of the highest value order placed by that client.
What is use of oracle?
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
How to do clean up if create database failed?
26. Display the earliest shipping date in the format: DD/MON/YYYY
24. Display the order number for all orders whose average item cost is greater than the overall average item cost across all orders.
List the various oracle database objects?
Oracle General 
