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 |
Explain what does a control file contain?
What is raw datatype in oracle?
What is flashback in Oracle?
Can we convert a date to char in oracle and if so, what would be the syntax?
What is Read-Only Transaction ?
how to retrieve data from different tables ,place this data in different excel worksheets.
what is primary key and foreign key when and where have to use
What happens if you use a wrong connect identifier?
What is raw datatype?
What is blob data type in oracle?
What happens to indexes if you drop a table?
what is the syntax of update command?