sqlite create table index code example

Example: 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);