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 to do if dba lost the system password?
Explain 1st, 2nd, 3rd normalization form of data base
How to rename a tablespace in oracle?
How will you differentiate between varchar & varchar2?
What is the difference between a primary key & a unique key?
What are a cluster and non-cluster index?
What are set operators?
What happens internally when the user types userID/password@string in SQL PLUS Thanks-Bhaskar
Explain the use of indexes option in exp command.
A USER HAVING CREATE SESSION PREVILAGE CAN ALTER PASSWORD/CHANGE PASSWORD?
WHAT IS ecc 6.0
How to create index-by table in oracle?