what is query optimizer? what are different types of
optimizer s supported by oracle ?
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 |
How do you call a module named �testmod.cfm� with the parameters param1=�yes� and param2=5?
What is up date strategy and what are th options for update strategy?
Explain in detail abt measure objects? And what is the use of it? How to create it?
Explain the different types of data warehousing?
Difference between slicing and dicing with example?
What is critical column?
What are fact, dimension, and measure?
What is ETL process in Data warehousing?
What is the difference between mapping parameter & mapping variable in data warehousing?
Explain what is the data type of the surrogate key?
How to export mappings to the production environment?
Explain dimensional modelling?