Re: Index compression vs. table compression

Noons wrote:

>>So to me, there really is no such
>>thing as a small lookup table anymore, I rarely see anything like
>>Daniel's example (even a "parameter" table I'm looking at has
>> thousands of rows).

>
> Exactly. My experience as well.

Help me out here ... which part of my example doesn't?

US Zip Code table contains 42,456 rows. A Canadian postal code table around 750,000 rows. But usages of the table are based on the primary key and those that are not almost always use an index.

What did I miss if anything?

Thanks.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)