create index/

CREATE INDEX
CREATE [ UNIQUE ] INDEX index_name ON table [ USING acc_name] ( column [ ops_name] [, ...] ) CREATE [ UNIQUE ] INDEX index_name ON table [ USING acc_name] ( func_name ( r">col le ...

SQL CREATE INDEX
Décrit l’importance d’une base de données contenant un index et de la syntaxe CREATE INDEX sous SQL.

MySQL :: MySQL 5.0 Reference Manual :: 13.2.4 Syntaxe de CREATE ...
CREATE [UNIQUE|FULLTEXT|SPATIAL] INDEX index_name [index_type] ON tbl_name (index_col_name,...) index_col_name: col_name [(length)] [ASC | DESC]

CREATE INDEX
CREATE [ UNIQUE ] INDEX index_name ON table [ USING acc_method] ( column [ ops_name] [, ...] ) [ WHERE predicate] CREATE [ UNIQUE ] INDEX index_name ON table [ USING acc_method ...