MISSION 116

Introduction to Indexing

Learn about how SQLite accesses data and how to use indexes to speed this up.

Objectives

  • Learn how the EXPLAIN query plan works.
  • Learn how to create a table index in SQLite.

Mission Outline

1. Introduction
2. Query planner
3. Explain query plan
4. Data representation
5. Time complexity
6. Search and rowid
7. Indexing
8. Create an index
9. All together now
10. Next steps
11. Takeaways

sql-databases-advanced

Course Info:

SQL and Databases: Advanced

Advanced

The median completion time for this course is 6.1 hours.

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

START LEARNING FREE