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 is exact difference between drop and truncate table.
What is clusters ?
What are the uses of linked server and explain it in detail?
Explain the concept of the DUAL table.
how to unbreak sequence numbers during intereptions
26. Display the earliest shipping date in the format: DD/MON/YYYY
how to get the second max val for every group in a table
How to assign a table row to a record variable?
Explain can a view based on another view?
How to pass parameters to procedures in oracle?
hey friends, What are the steps I can do to transfer the database from Microsoft Access 2003 to oracle10g (or SQL) Best regards
What is max rowid in oracle?