Syntax
[##] index [unique] on tablename is indexname
(columnname {, columnname})
[with_clause]
The optional with_clause must consist of a comma-separated list of one of more of the following:
structure = btree | cbtree | isam | cisam | hash | chash
key = (columnname {, columnname})
fillfactor = n
minpages = n
maxpages = n
leaffill = n
nonleaffill = n
maxindexfill = n
location = (locationname {, locationname})
allocation = n
extend = n