advancedDatabase Optimization Techniques
What is a covering index and how does it eliminate table lookups entirely for a query?
Tests whether you know an index that already contains every selected column skips the extra trip to the actual table row.
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 covering index and how does it eliminate table lookups entirely for a query?