What are the factors that affect OPTIMIZER in choosing an
Optimization approach ?
- 2 Answers
- 3622 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 do you find out from the RMAN catalog if a particular archive log has been backed-up?
What is the usage of synonyms?
what are the default admin accounts in Oracle 10g ?
How to list all user accounts in oracle?
What do you mean by redo log file mirroring?
What is private procedure oracle?
How to view existing locks on the database?
Explain the use of rows option in exp command.
How to check database size in Oracle?
What is the difference between truncate & delete command?
WHAT IS ecc 6.0
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.
How to do a full database export?
How can we find out the duplicate values in an oracle table?
What is the difference between hot backup and cold backup in oracle?
