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
- 13175 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 Factless fact table? In which purpose we are using this in our DWH projects?Plz give me the proper answer. Thanks, Ramesh
What is the use of incremental aggregation? Explain me in brief with an example?
What is ods (operation data source)?
I know of using applysimple, but there are other ways too?
What is critical column?
Which columns go to the fact table and which columns go the dimension table?
What a static and local variable?
What is surrogate key? Where we use it?
What are non-additive facts in detail?
In general, how many Fact & Dimension tables are present in a Banking Data warehouse project ?
What is difference between model & package?
Whether dimension table can have numeric value?
Teradata 
