GET 24/7 LIVE HELP NOW

Announcement

Announcement Module
Collapse
No announcement yet.

Indexing

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • 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?

  • #2
    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;

    Comment


    • #3
      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

      Comment


      • #4
        Yes the default index for MEMORY table is HASH.

        And you can use this:
        SHOW CREATE TABLE yourTable
        to see the exact table definition, including the indexes.

        Comment

        Working...
        X