Answer Posted / 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 |
Post New Answer View All Answers
if you ctreate table identity
What is a table index in oracle?
What is the difference between Delete, Truncate and Drop in Oracle?
Is oracle an operator?
What is recycle bin in Oracle?
What are the differences between number and binary_float in oracle?
HI, Please let me know the syllabus for Oracle OCA and OCP Certification
Using the relations and the rules set out in the notes under each relation, write table create statements for the relations EMPLOYEE, FIRE and DESPATCH. You should aim to provide each constraint with a formal name, for example table_column_pk.
What is different types of joins?
What are the predefined tablespaces in a database?
What are the limitations oracle database 10g xe?
Explain the difference between sql and oracle?
How to save query output to a local file?
How many types of table in Oracle?
What are the ways tablespaces can be managed and how do they differ?