>_ IzzyLab

Topic breakdown

An index is an auxiliary sorted structure that lets the database quickly find rows by a column's value without scanning the whole table sequentially (a full scan). The trade-off is a bit more disk space and a small slowdown on inserts, but selections on the indexed column speed up dramatically. An index is created with the CREATE INDEX statement, specifying the name, table, and column. SQLite keeps the list of all database objects, including indexes, in the system table sqlite_master.

What's checked

  1. index idx_user created
  2. the index is built on events(user_id)

What it looks like