Indexing

Hi All,

How do we create the B-Tree and hash indexing in mysql ?

How we come to know that the table hash B-Tree or hash indexing?

Well since HASH index is only available for MEMORY/HEAP tables and MySQL cluster there isn’t so much of an option.

SHOW INDEXES FROM yourTable;

Hi,

Thanks for the reply.

But how do we know it is hash index or b-tree index. In point of view, b-tree and hashing indexing is available in memory storage engine.

I want to clear myself when we create the index in memory storage engine , then default index is hashing index.

Thanks in advance