CODE EXAMPLE FOR SQL

sqlite create index

-- CREATE [UNIQUE] INDEX index_name ON table_name(column_list);
CREATE UNIQUE INDEX idx_contacts_email ON contacts (email);
CREATE INDEX customer_idx ON customers (state, city);