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

Course Info:

SQL and Databases: Advanced

Advanced

The average completion time for this course is 10-hours.

This course requires a basic subscription. This course includes four paid 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

Share On Facebook
Share On Twitter
Share On Linkedin
Share On Reddit