ALTER TABLE COLUMN ADD INDEX
Indexes an existing
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.
For more information about indexes please refer to the INDEX documentation
Adding an index
ALTER TABLE trades ALTER COLUMN instrument ADD INDEX;