MISSION 116
Introduction to Indexing
Learn about how SQLite accesses data and how to use indexes to speed this up.
Objectives
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
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.