Indexes and EXPLAIN QUERY PLAN
Make lookups fast with CREATE INDEX, read EXPLAIN QUERY PLAN to see SCAN turn into SEARCH, and learn which queries an index can and can't help.
- The skill
- Make lookups fast with indexes and read a query plan to check them.
- You make
- Indexes for a game launcher's busiest pages.
Premium lesson
£7.99 a month or £59 a year. Cancel any time.
Builds on 29 Views, saving a query under a name. Free to try: SQL Foundations and the playground.
Passed
You can now
You have what you need for a project: Build a music database Premium 2.5 hours
Step 1 of 8
exercise_1.sql
You've reached the good stuff.
5 exercises in this lesson, checked as you type. Premium opens every lesson after Foundations, in all four courses.
SQLite