Re: Hash Clustered Table Question

From: Mladen Gogala <>
Date: 10 Jun 2008 15:54:23 GMT
Message-ID: <484ea3af$0$30638$>

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".

Received on Tue Jun 10 2008 - 10:54:23 CDT

Original text of this message