W4111 – Introduction to Databases Sections 002
Introduction to Databases Sections 002
Hello, dear friend, you can consult us at any time if you have any questions, add WeChat: THEend8_
W4111 – Introduction to Databases Sections 002
Question 1: Explain why a sparse index must also be a clustering index.
Question 2: Briefly explain sparse, multi-level indexes and their benefits. Why can the outer index be sparse?
Question 3: Indexes can significantly improve performance? What are some disadvantages of having many indexes?
Question 4: Briefly compare the pros and cons of B+-Tree versus a Hash Index.
Question 5: Briefly explain the concepts of covering index/covered query.
Question 6: Briefly explain the three main steps/stages in query processing.
Question 8: Explain the role of equivalent queries in query optimization.
Question 9: Assume that the ON clause in a JOIN on tables A and B compares columns a1 with b1 and column a2 with b2. What two properties must the ON condition have for the optimizer to be able to use a Hash Join?
Question 10: What is index selectivity? How does it factor into query optimization for JOINs?