INDEX Constraint
An INDEX is used to speed up the retrieval of data from a table. Indexes are created on columns that are frequently queried.
Example: Creating an INDEX
CREATE INDEX idx_city_name
ON Cities (CityName);Explanation: An index named idx_city_name is created on the CityName column, improving query performance.