Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-13445

Hash-Index Type for InnoDB

    XMLWordPrintable

    Details

      Description

      I want to use Hash Indexes also on the Storage Engine InnoDb.

      I have a lot of Hash-Values in my table's which I create via hex(md5(<value>)) function and store them in a BINARY(16) column.

      In my JOIN's I using them via USING(column), I not order them. So I would expect dramatic performance improvements if the underlying Index is not a B-Tree but also Hashing (ideal the value itself is used also in the index).

      I doing this for a Data-Vault 2.0 Core Model which heavy use MD5 represantation of Business-Key for references the SAT's and the HUB's and the LNK's.

        Attachments

          Activity

            People

            Assignee:
            Unassigned Unassigned
            Reporter:
            Stefc Stefan Böther
            Votes:
            1 Vote for this issue
            Watchers:
            4 Start watching this issue

              Dates

              Created:
              Updated:

                Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.