Put in order · SQL and MySQL course · Module 9: Indexes and normalization
Ways of finding a scroll
Arrange the ways of finding a scroll from the slowest to the fastest:
Items to put in order
- Looking into the index, then into the pointed-to row
- Hitting it directly by the primary key (the right row at once)
- Full table scan (going through every row in turn, with no catalog)
You can check the correct answer by solving this task in the CodeWorlds game.