soccer_champ

• Jun 20th, 2005

 

Hash clusters are useful in cases where : 
(i) There is a uniform, even and predictable no. of key values. 
(ii) Queries using equality predicates. 
(iii) The table is NOT growing constantly, and the keys are rarely updated.

Rani Rathna

• Jul 9th, 2005

 

hash cluster --> preallocated based on number of keys and key size. 
 
index cluster --> not preallocated 
 
in both cases, you want to get the key size (amount of data associated with a given key) as good as possible, but with hash clusters understanding the uppper bound on the ultimate number of keys is very relevant