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.