June 2001
Intermediate to advanced
688 pages
19h 18m
English
The database hash determines in which bucket a particular key will reside. The goal of hashing keys is to distribute keys equally across the database pages; therefore, it is important that the hash function work well with the specified keys so that the resulting bucket usage is relatively uniform. A hash function that does not work well can effectively turn into a sequential list.
No hash performs equally well on all possible datasets. It is possible that applications may find that the default hash function performs poorly with a particular set of keys. The distribution resulting from the hash function can be checked using the db_stat utility. By comparing the number of hash buckets and the number of keys, one can ...