CREATE INDEX is used to create an index on one or more columns. See Chapter 21 for more information.
• Input
CREATE INDEX indexname ON tablename (column [ASC|DESC], ...);