The CREATE INDEX statement is used to create indexes on one or more columns in a table. Indexes improve query performance by speeding up searches. Effect: Indexes are used to boost performance when ...