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 |
There is a big table with "n" of rows and 40 + columns .It doesn't have primary key.How do you select the primary key. In other words how do you get the duplicate records.
In AP we done Customizations for Late Payments Charges. For Reporting Purpose What are the Documents Prepared for Customer Understanding??
How to save query output to a local file?
Explain the relationship among Database, Tablespace and Data file?
What is a shared pool?
Table Has C1 And C2 Column If Exits any record in c1 then Update c2 record Otherwise insert new record in the C1 And C2 (Using Procedure)
What is a Private Synonyms ?
Her departmandaki isçilerden empno' su ikinci sirada olan isçilerin empno, deptno, hiredate, sira_no bigilerini döndüren sorguyu yaziniz?
How to invoke the original export import utilities?
what diffrence between function and procedure?
How to define a data source name (dsn) in odbc manager?
Is it possible to center an object horizontally in a repeating frame that has a variable horizontal size ?