Full table scannot run yet
–disk reads
–checked in RAM
–time
Index lookupnot run yet
–disk reads
–checked in RAM
–time
key → (page, slot). The root narrows the search to one leaf, binary search finds the entry, and only one data page is read.WHERE name = … query can't use an index on id.| Space | Play / pause |
| → ← | Next / previous step |
| Home End | Start of run / skip to end |
| R or Enter | Run the query |
| S X | Full scan / use index |
| C | Compare both |
| L | LIMIT 1 on / off |
| E | Empty RAM |
| T | Tour |
| I | Type a value |
| ? | This help |
Created by