What is RULE-based approach to optimization ?
- 1 Answers
- 4686 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 |
Give the different types of rollback segments.
How do you increase the OS limitation for open files (LINUX and/or Solaris)?
What is data block in Oracle?
What are the different windows events activated at runtime ?
Explain the use of ignore option in imp command.
How to end the current transaction in oracle?
why pl sql doesn't support retrieving multiple records
Explain the use of analyse option in exp command.
What is the difference between hot backup and cold backup in oracle? Tell about their benefits also.
Can you have more than one content canvas view attached with a window ?
How to define an anonymous block?
What are the four Oracle system processes that must always be up and running for the database to be useable?
Oracle General 
