Details
-
Task
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
None
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
Issue Links
- relates to
-
MDEV-371 Unique indexes for blobs
- Closed
-
MDEV-31072 InnoDB is USING HASH and Optimizer is confused
- Open
-
MDEV-31615 SHOW INDEX returns Index_type BTREE for Index_type HASH
- Closed