What is RULE-based approach to optimization ?
Answer / kalyani
Rule Based Optimizer (RBO) - This method is used if the
server has no internal statistics relating to the objects
referenced by the statement. This method is no longer
favoured by Oracle and will be desupported in future
releases
| Is This Answer Correct ? | 2 Yes | 0 No |
What is a user role in oracle?
How to connect asp pages to oracle servers?
What happens if variable names collide with table/column names?
What are the components of physical database structure in the Oracle database?
There are three tables : E : EID,ENAME D : DID,DNAME empdept : eid, did select the employees who doesn't belong to any dep
how to we delete a row using varray
where do i find oracle interview questions.
A table t is there.If you perform insert ,update and delete then the trigger will fire.What is the minimum no of trigger required for a table.
What is hot backup and logical backup?
What is the maximum number of triggers that can be applied to a single table?
Why does for update in oracle 8 cause an ora-01002 error?
Explain can a view based on another view?