advancedDatabase Optimization Techniques
What is a composite index, and when does column order inside it actually matter?
Tests whether you know a composite index is only useful for queries that filter on its leftmost columns first.
This is a Pro question
Sign in, then upgrade to Pro or Power to unlock this question and the full Interview Prep bank.
What is a composite index, and when does column order inside it actually matter?