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
- 3970 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 |
Is it possible to enter only time value into a column of a table in sql?
what is difference between foreign key and reference key
1:-How to write to update command in a procedure in oracle which update two different table at a time 2:-How to write the select command in a procedure in oracle which give multiple records
How to run create database statement?
What is bulk load in oracle?
16. Display the order number, order line number and the shipping date. If the shipping date is null, display the string <not shipped yet>.
What are the database administrators utilities available?
Explain oracle instance.
which is best institue to learn oracle 11i in ameerpet or maithrivanam or sr nagar please help
How to insert a new row into a table in oracle?
21. Using a set operator, display the client number of all clients who have ever placed an order and whose whose name does not contain the string Sm.
What is the difference between substr and instr?
Oracle General 
