Interested to Buy Any Domain ? << Click Here >> for more details...
What is RULE-based approach to optimization ?
- 1 Answers
- 5209 Views
- I also Faced
- E-Mail Answers
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 are the components of logical database structure in oracle database?
List the various oracle database objects?
What would you do with an in-doubt distributed transaction?
Give the different types of rollback segments.
what is the use of system.effective.date variable in oracle?
Explain the use of tables option in exp command.
How to Truncate Table in Oracle
What is an Oracle index?
Explain the use of analyse option in exp command.
What are the Referential actions supported by FOREIGN KEY integrity constraint ?
Display the records between two range?
Whats the benefit of dbms_stats over analyze?
Oracle General 
