ALTER TABLE COLUMN ADD INDEX

Indexes an existing symbol column.

Syntax

ALTER TABLE tableName ALTER COLUMN columnName ADD INDEX;

Adding an index is an atomic, non-blocking, and non-waiting operation. Once complete, the SQL optimizer will start using the new index for SQL executions.

Example

Adding an index

ALTER TABLE trades ALTER COLUMN side ADD INDEX;