What is the effect of setting the 'RULE' for OPTIMIER_GOAL
parameter of the ALTER SESSION Command ?
Answer / guest
This value causes the optimizer to choose the rule-based
approach for all SQL statements in a session regardless of
the presence of statistics
| Is This Answer Correct ? | 0 Yes | 0 No |
i have executed the Delete command after the I have created table whether deletions will be commit or not? if table is successfully created?
What is the diff between Oracle and SQL Server
What is a table index in oracle?
How to create a new table in oracle?
How to load data from external tables to regular tables?
ur a sql devoloper...what is the process in ur company for finding the database BUGS .. seperate DB testers are there? or devr.s are manage? if DB TESTERS in there what is the process
Explain the difference between sql and oracle?
DBMS vs. RDBMS
What is STATSPACK tool?
Differnce between view and index
Will the Optimizer always use COST-based approach if OPTIMIZER_MODE is set to "Cost"?
How to create a testing table in oracle?