1. What is the goal of query optimization? Why is it important?
2. Describe the advantages of pipelining.
3. Give an example in which pipelining cannot be used.
4. Describe the iterator interface and explain its advantages.
5. What role do statistics gathered from the database play in query optimization?
6. What information is stored in the system catalogs?
7. What are the benefits of making the system catalogs be relations?
8. What were the important design decisions made in the System R optimizer?