SQL Data Analyst — Medium
Key points
- Covering index includes all query columns
- Reduces I/O by avoiding table access
- Improves query performance by fetching data from the index
- Does not physically order table data like a clustered index
Ready to go further?
Related questions
