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 |
What are the extensions used by oracle reports?
How to store pictures on to the database?
HI ALL, CAN ANYONE TELL ME THE DIFFERENCES BETWEEN SQL CLUSTURS,MSQL CLUSTERS,ORACLE CLUSTERS.......THANKS IN ADVANCE
Explain alias?
What is bind variable in oracle 11g?
write a query that displays every Friday in a year with date?
How to change program global area (pga) in oracle?
What does sharding mean?
State the difference between a primary key and foreign key?
What is Oracle table?
What are the data types in oracle?
2. Display the post code and the total number of purchase orders placed with creditors in that post code.