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
- 3898 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 |
Explain the use of indexes option in imp command.
SELECT * FROM (SELECT TITLE FROM MOVIE ORDER BY RANK DESC) WHERE ROWNUM > 4; when i run the above query .it produces output as NO ROWS SELECTED.why ?plz any one help me
Which Oracle App Is Most Popular One ?
does Oracle has only one table space?
How to select an oracle system id (sid)?
what is Single Byte Overhead...?
What is oracle in java?
What is memory advisor in Oracle?
What is a Data File ?
Oracle
0 Answers ABC, Genpact, HUI, Oracle,
How to test null values?
How can I see all tables in oracle?
Oracle General 
