Sample questions

• Under what circumstances would a filtered index oversimplification lead to a problem when index-based query optimizations are assumed?
• What happens to the performance when a composite index covering (A, B) is queried with conditions only on B?
• Given a database with automatic index management, what unexpected behavior might occur during heavy write operations?