Harvinder, How about a simple database table that associates the account with the bucket? I'm not exactly sure what you mean by "bucket". What exactly are you storing? Tom Mercadante Oracle Certified Professional -----Original Message----- From: Harvinder Singh [mailto:Harvinder.Singh@xxxxxxxxxxxxx] Sent: Monday, October 18, 2004 10:59 AM To: oracle-l@xxxxxxxxxxxxx Subject: Help with hash function Hi, We have a requirement that we need to separate our accounts (one of column in table) into 1024 buckets so I am thinking of applying hash function to this column and based on the hash send the account to one of bucket.=20 So basically we have to write a hash function that will take 1 input and associate it will particular bucket and it is deterministic that for each value it will always send it to same bucket. Any article or link will be helpful that can explain how to write this hash function? Thanks --Harvinder -- //www.freelists.org/webpage/oracle-l -- //www.freelists.org/webpage/oracle-l