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 |
How different is ms access and oracle?
How can I convert single byte kana characters into multi byte kana characters and vice-versa.
What is an oracle data file?
Explain a data segment?
How to filter out duplications in the returning rows using oracle?
An automatic job running via DBMS_JOB has failedKnowing only that its failed, how do you approach troubleshooting this issue?
12. Display the client name in upper case only and in lower case only.
What is partitioned table in Oracle?
What is raw datatype?
What is the purpose of a cluster?
Why is oracle so popular?
i have a table with the columns below as Emp_ID Address_ID Address_Line City Country -------- --------- ----------- ------ --------- Q: Display the Emp_ID's those having more than one Address_ID