1CREATE INDEX calpont.index_name ON calpont.tbl_name(col_name); 2CREATE INDEX calpont.index_name ON calpont.tbl_name(col_name(10)); 3CREATE INDEX index_name ON tbl_name(col_name,col_name); 4CREATE INDEX calpont.index_name ON calpont.tbl_name(col_name,col_name) engine=infinidb; 5