What is the effect of setting the 'RULE' for OPTIMIER_GOAL
parameter of the ALTER SESSION Command ?
- 1 Answers
- 3435 Views
- I also Faced
- E-Mail Answers
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 |
What is Hash Cluster ?
What the is the diff between local index and global index. give some example.
What is meant by redo log buffer ?
HOW TO CONVERT ORACLE TABLE DATA (RECORDS)INTO EXCEL SHEEET?
What is the effect of setting the value of OPTIMIZER_MODE to 'RULE' ?
why dont we assign not null constraint as table level constraint.
consider some table with 4 r 5 columns in that 1 col is DATE type. The data is like that,For each date in that col some 3 fields r there but all the records r having different data. Now i want to display all the columns by performing grouping on the date field ( as SELECTION Operator(*) cannot be used with group function having only one "group by clause". how to do this? can any one help me in finding out the solution plss?
how to find the n'th highest salary from emp ?
What are ddl statements in oracle?
when loggined as SYSTEM,how to display all the users of database using sql query?
What is a OUTER JOIN?
What are advantages of dateset in datastage?
Oracle General 
