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