CREATE INDEX idx_name_district
ON city (Name, District)
| After the CREATE INDEX command, the index name is specified. This is followed by the ON statement, followed by the name of the table to add the index to. Indexes are mainly used for: ✓ Speeding up queries with filtering in WHERE. ✓ Speeding up data sorting. ✓ Speeding up data grouping. |