What are the factors that affect OPTIMIZER in choosing an
Optimization approach ?
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 |
What is a trace file and how is it created in oracle?
without using count(*) and rownum how can we count total record in a table
How can we view last record added to a table?
What is oracle thin client?
what are actual and formal parameters?
What are the limitations of check constraint?
Explain coalesce function?
Is a rollback possible to any savepoint?
Explain what are the different type of segments?
how to code performance tuning of oracle PL/SQL? can any body send me the perfect answer?
What are main difference between Stored Procedure and Functions.
What is PL/SQL ?