xref: /dports/databases/mariadb105-server/mariadb-10.5.15/storage/columnstore/columnstore/dbcon/ddlpackage/sql/examples/create-index.sql

CREATE INDEX calpont.index_name ON calpont.tbl_name(col_name);
CREATE INDEX calpont.index_name ON calpont.tbl_name(col_name(10));
CREATE INDEX index_name ON tbl_name(col_name,col_name);
CREATE INDEX calpont.index_name ON calpont.tbl_name(col_name,col_name) engine=infinidb;