- Published on
Investigation · Part 1 of 10 · Inside a database index
An Index Is a Second Copy of Your Data
I added one index to a SQLite table of one million users and read the file page by page. The index is a second sorted copy of the emails, each one with the rowid of its row, and when I broke one entry the database returned a row that does not exist.