What are the approaches used by optimizer during execution plan?
- 1 Answers
- 1010 Views
- I also Faced
- E-Mail Answers
Answer / Kusum Rani
The optimizer in a database system uses various strategies to create an execution plan for SQL queries. These strategies include rule-based optimization, cost-based optimization, and hybrid optimization. Rule-based optimization follows predefined rules, while cost-based optimization estimates the cost of each operation and chooses the most efficient one based on that estimation. Hybrid optimization combines both approaches.
| Is This Answer Correct ? | 0 Yes | 0 No |
Explain what is a staging area? Do we need it? What is the purpose of a staging area?
What is an error log table in informatica occurs and how to maintain it in mapping?
Explain what are the modules in power mart?
What we will do with the universe for faster process?
What are the differences between datamart vs. Reporting cube?
What is bi?
What is called data cleaning?
hi i have 2 users and 4 reports in dashboard.i have to give rights 2 reports for every users. is it possible give the rights in dashboard.if yes plz let me know how is it possible . thanks in advacne for appreciation. bye rohit
What is the difference between filter and lookup transformation?
capital of tamilnadu
What is the difference between aggregate table and materialized view?
Explain what are the various transformation available?
Teradata 
