What is the method for adding indexes in ClickHouse?

In ClickHouse, you can use the following syntax to add an index:

ALTER TABLE table_name ADD INDEX index_name (column_name);

Among them, table_name refers to the name of the table where the index will be added, index_name is the name of the index to be added, and column_name is the name of the column where the index will be created.

For instance, to add an index named my_index to the my_column column in a table named my_table, you can execute the following statement:

ALTER TABLE my_table ADD INDEX my_index (my_column);