Interested to Buy Any Domain ? << Click Here >> for more details...
what is query optimizer? what are different types of
optimizer s supported by oracle ?
- 1 Answers
- 13144 Views
- ABC, I also Faced
- E-Mail Answers
Answer / subhendu
The query optimizer is the component of a database
management system to optimize the query. Query optimization
is a function of many relational database management
systems in which multiple query plans for satisfying a
query are examined and a good query plan is identified.
Oracle supports two different Oracle query optimizers, a
rule-based optimizer and a cost-based optimizer. With
Oracle Database 10g, the rule-based optimizer is
desupported.
| Is This Answer Correct ? | 27 Yes | 1 No |
What is a Decision Tree Algorithm?
What is data stream and data adaopter?
How can we do data cleaning?
What is "method/1"?
How do you create surrogate key using ab initio?
What is Time Series algorithm in data mining?
How do you call a module named �testmod.cfm� with the parameters param1=�yes� and param2=5?
How to provide security in frame work manager for a query subject?
difference between For each and for all
Explain the difference between data ware house & data mart?
What is data analysis? Where it will be used?
What is a Data Cube?
Teradata 
