MISSION 117

Multi-column indexing

Learn how to take advantage of indexing when querying multiple columns.

Objectives

  • Learn how to use multi-column indexing to speed up certain queries.
  • Learn how to understand a multi-column query plan.
  • Learn what a covering index is.

Mission Outline

1. Introduction
2. Query Plan
3. Query plan for multi-column queries
4. Explanation
5. Multi-column index
6. Creating a multi-column index
7. Covering index
8. Covering index for single column
9. Conclusion
10. Takeaways

sql-databases-advanced

Course Info:

Advanced

The median completion time for this course is 6.1 hours. View Details

This course requires a basic subscription. This course includes four missions and one installation tutorial.  It is the 13th course in the Data Analyst in Python path and Data Scientist in Python path.

START LEARNING FREE

Take a Look Inside