Re: KEY partitioning not using all partitions?
Hi,
Is it a regular hex string (only consisting in 0-9,a-f characters)?
Then I would suggest trying to store the raw (not converted to hex string) data as a BINARY CHAR(<data length in bytes>) instead, then the HASH algorithm used by KEY partitioning would do a better job, and you will also save space in the table.
(My guess is that if you only use a small subset of characters, it might only be hashed to even or odd values, resulting in only the even/odd partitions will be used.)
Subject
Views
Written By
Posted
3393
December 09, 2008 07:14PM
Re: KEY partitioning not using all partitions?
2684
December 11, 2008 05:52AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.