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 |
When do you get a .pll extension in oracle?
What is different types of joins?
Explain the use of record option in exp command.
The table has 3 columns 4 rows. The output is which column has least null values( A COL SHOULD BE THE OUTPUT) Write the query plz. A B C ---------- 1 NULL 7 2 4 NULL NULL 5 NULL 3 NULL NULL
how to get the index id?
How to insert multiple rows with one insert statement in oracle?
How to retrieve first and last records from a table?
What are the roles of dba?
How to create a new view in oracle?
How to use "while" statements in oracle?
what is normalisation?what are its uses?
What is the best way to do multi-row insert in oracle?