Interested to Buy Any Domain ? << Click Here >> for more details...
What are the factors that affect OPTIMIZER in choosing an
Optimization approach ?
- 2 Answers
- 4604 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / guest
The OPTIMIZER_MODE initialization parameter Statistics in the
Data Dictionary the OPTIMIZER_GOAL parameter of the ALTER
SESSION command hints in the statement.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / 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 |
Does rowid change in oracle?
How to lock and unlock a user account in oracle?
What is sharded cluster?
What are the uses of Rollback Segment ?
What are the factors causing the reparsing of SQL statements in SGA?
how to handle exceptions in post production
Preparing for Oracle PL/SQL Interviews – Need Help with Common Questions
Explain 1st, 2nd, 3rd normalization form of data base
What is Redo Log Buffer in Oracle?
Hi Can any one tell me what are the API's used in requisition import.
How to delete a user account in oracle?
What is a OUTER JOIN?
Oracle General 
