What is the effect of setting the value of OPTIMIZER_MODE
to 'RULE' ?
Answer / guest
This value causes the optimizer to choose the rule_based
approach for all SQL statements issued to the instance
regardless of the presence of statistics.
| Is This Answer Correct ? | 0 Yes | 1 No |
Explain temporal data types in oracle
What are the predefined tablespaces in a database?
How many types of database triggers exist?
What is the difference between hot backup and cold backup in oracle? Tell about their benefits also.
Hi Can any one tell me what are the API's used in requisition import.
difference between oracle8i and oracle9i
1. Display all the rows and columns in the CLIENT table. Sort by client name in reverse alphabetical order.
how to get the index id?
How do we switch from init.ora file to asp file?
What do database buffers contain?
How to view the dropped tables in your recycle bin?
How to use "out" parameter properly?