CONCURRENTLY
Example
Section titled “Example”CREATE INDEX CONCURRENTLY idx_column ON table_name(column_name);Output
Section titled “Output”Query returned successfully with no result in 200 ms.Explanation
Section titled “Explanation”The CREATE INDEX CONCURRENTLY statement is used to create an index without locking the table. The locking of the table would otherwise prevent any modifications on the table. The example provided creates an index on column_name in table_name. The execution time may vary depending on the size of the table. This command does not output any data.