Interested to Buy Any Domain ? << Click Here >> for more details...
What is RULE-based approach to optimization ?
- 1 Answers
- 5196 Views
- I also Faced
- E-Mail Answers
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 |
Is oracle an operator?
Explain the use of grant option in exp command.
when loggined as SYSTEM,how to display all the users of database using sql query?
How can you tell how much space is left on a given file system and how much space each of the file systems subdirectories take-up?
How to use "in out" parameter properly?
Explain the relationship among Database, Tablespace and Data file?
How to retrieve data from an explicit cursor?
State the difference along with examples between Oracle 9i, Oracle 10g and Oracle 11i.
What is flashback in Oracle?
What are the tools for Oracle ?
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)
Explain the family trees and connection by clause
Oracle General 
