# Indexing

**URL:** <https://forums.percona.com/t/indexing/1255>\
**Category:** Other MySQL® Questions\
**Created:** [September 8, 2009, 12:54am UTC](https://forums.percona.com/t/indexing/1255 "2009-09-08T00:54:20Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![ervaneet82](https://avatars.discourse-cdn.com/v4/letter/e/c68b51/32.png) [@ervaneet82](https://forums.percona.com/u/ervaneet82)\
**Post date:** [September 8, 2009, 12:54am UTC](https://forums.percona.com/t/indexing/1255/1 "2009-09-08T00:54:20Z")

</div>

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?

---

<div class="post-metadata">

**Author:** ![sterin71](https://avatars.discourse-cdn.com/v4/letter/s/5e9695/32.png) [@sterin71](https://forums.percona.com/u/sterin71)\
**Post date:** [September 8, 2009, 3:51pm UTC](https://forums.percona.com/t/indexing/1255/2 "2009-09-08T15:51:13Z")

</div>

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;

---

<div class="post-metadata">

**Author:** ![ervaneet82](https://avatars.discourse-cdn.com/v4/letter/e/c68b51/32.png) [@ervaneet82](https://forums.percona.com/u/ervaneet82)\
**Post date:** [September 10, 2009, 1:36am UTC](https://forums.percona.com/t/indexing/1255/3 "2009-09-10T01:36:11Z")

</div>

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