create index syntax

[kehers]

I seem to understand the "Unique" and "fulltext" options in the create index table syntax that goes this way:

create index [unique | fulltext | spatial] index
index_name [index_type]
on tbale_name [index_col_name,...)

however i'd luv an explanation on spatial indexes and index_types

 

[TonyGroves]

Spatial indexes only apply to geometric fields, which I know nothing about, but it's explained in the MYSQL manual. The index type specifies the index technology you want to use (for performance reasons); currently only MEMORY tables offer you a choice. Again, this is explained in the manual.