Question 1: What is the objective of a query simplifier? What are the idempotence rules used by query simplifier? Give an example to explain the concept.
Question 2: What are query transformation rules?
Question 3: Discuss the rules for transformation of query trees and identify when each rule should be applied during optimization.
Question 4: Discuss the main cost components for a cost function that is used to estimate query execution cost.
Question 5: What cost components are used most often as the basis for cost functions?