Glossary: SQL Beyond the Basics
Index
Also written: indexes, CREATE INDEX
A separate sorted list of one or more columns with pointers back to the rows, like a book's index. It lets SQLite jump straight to matching rows instead of scanning the table.
Glossary: SQL Beyond the Basics
Also written: indexes, CREATE INDEX
A separate sorted list of one or more columns with pointers back to the rows, like a book's index. It lets SQLite jump straight to matching rows instead of scanning the table.