The SQLite Bytecode Engine (has opcode references)
SQL references
How SQLite is Tested
See tables and indices:
SELECT name FROM sqlite_master
WHERE type='table'
;
SELECT name FROM sqlite_master
WHERE type='index'
;
-- Single index
-- Table: books field: author_id
CREATE INDEX index_books_on_author_id on books(author_id)
;
DROP INDEX index_books_on_author_id
;
-- Compound index
-- Table: books_readers fields: user_id, book_id
CREATE INDEX index_books_readers_on_user_id_and_book_id on books_readers(user_id, book_id)
;
DROP INDEX index_books_readers_on_user_id_and_book_id
;
EXPLAIN SELECT
EXPLAIN QUERY PLAN SELECT
SCAN TABLE = Full Table Scan
SEARCH TABLE = Search part of Table by some indexes