Interested to Buy Any Domain ? << Click Here >> for more details...
What are the factors that affect OPTIMIZER in choosing an
Optimization approach ?
- 2 Answers
- 4814 Views
- I also Faced
- E-Mail Answers
Answer Posted / nishi
This value causes the optimizer to the cost-based approach for all SQL statements in the session regardless of the presence of statistics and to optimize with a goal of best throughput.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to drop an index in oracle?
How to create a temporary table in oracle?
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracles. What database recovery options are available? Database is in archive log mode.
What are the limitations oracle database 10g xe?
What is a tns service name?
What happens to indexes if you drop a table?
Please explain joins in oracle?
Explain the importance of .pll extension in oracle?
How to convert dates to characters in oracle?
Explain the use of indexes option in imp command.
what is reindexing?
What is a Garbage Collection? and what is full recursive Garbage collection?
How to get execution path reports on query statements?
How to define an oracle sub procedure?
What is varray?
