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 are transaction isolation levels supported by oracle?
How to use "in" parameter properly?
what are Triggers?
Table Has C1 And C2 Column If Exits any record in c1 then Update c2 record Otherwise insert new record in the C1 And C2 (Using Procedure)
How to grant create session privilege to a user in oracle?
How to Truncate Table in Oracle
How to define an anonymous block?
Can we insert data in view oracle?
What is Public Database Link ?
How to get execution path reports on query statements?
please explain.. DB architecture ...
how to retrive xml data for using sql query?