Hi,

I have table (MyIsam) and want to set an index but fail to do so.

Field : Varchar(10) Not Null
Index Type : Unique
Index Method : Hash

Everytime I try, index method automatically assigned as BTree. Is this combination wrong for setting an index defined above?

Thanks

Recommended Answers

Storage Engine    Permissible Index Types
InnoDB            BTREE
MyISAM            BTREE
MEMORY/HEAP       HASH, BTREE 
NDB               HASH, BTREE (see note in text)

Taken from: http://dev.mysql.com/doc/refman/5.6/en/create-index.html

Jump to Post

All 2 Replies

Himmm. I'll read it a bit more then.
Thanks

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.21 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.