Re: Hash Clustered Table Question

From: Mladen Gogala <mgogala_at_yahoo.com>
Date: 10 Jun 2008 15:54:23 GMT
Message-ID: <484ea3af$0$30638$834e42db@reader.greatnowhere.com>


On Mon, 09 Jun 2008 20:20:34 -0400, Dereck L. Dietz wrote:

> I've never used hash tables before but wanted to experiment. I have a
> small lookup table with only 110 rows. If I make that into a hash
> clustered table will the hash key suffice or would I also have to
> include a primary key?

You can have both. Hash tables are poor man's partitioning and are used for static ("search") tables with low cardinality but frequently used column, like "gender" or "status".

-- 
http://mgogala.freehostia.com
Received on Tue Jun 10 2008 - 10:54:23 CDT

Original text of this message