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 |
In what script is snap$ created? In what script is the scott/tiger schema created?
Can a formula column be obtained through a select statement ?
What is a tns service name?
I want a table like, no name address addr1 addr2 So i want columns like addr1,addr2 under address column. Can one please answer me. Advance Thanks.
What is ordinary table in oracle?
query to find the maximum no persons with same age(age colomn) from emp table
List the various oracle database objects?
What are the types of partitions in oracle?
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
Why packages are used in oracle?
What is the difference between normal and corelated subqueries?
Anybody can tell me, how do we find second largest emp salary from emp table.. Thanks in advance ...
10 Answers Cognizant, ID, NTTF Nettur Technical Training Foundation, Sony, Verizon,