MySQL InnoDB table with a Hash Index

Viewed 5154

I have a table like this.

ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

Later i have created a HASH index like this.

CREATE INDEX index ON table (column) USING HASH;

Latter i have try some explain queries.

Like

explain Select * from table where column=132;

And i see the engine is using the index on possible_keys and in the key stuff says the name of the index!!

But in the docs says that InnoDB doesn't allow hash index now i wonder why my innoDB Supposedly allows the hash index?

2 Answers
Related