Re: Hash Clustered Table Question
Date: 10 Jun 2008 15:54:23 GMT
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