Index

Create index in table

• Create and Use Indexes

CREATE INDEX INDEX_NAME ON TABLE_NAME (COLUMN_NAME);

CREATE INDEX INDEX_NAME ON TABLE_NAME (COLUMN_NAME_1, COLUMN_NAME_2);

CREATE INDEX INDEX_NAME ON TABLE_NAME (COLUMN_NAME) ONLINE;