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