Re: Index compression vs. table compression

DA Morgan wrote:
> 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?

The application that allows you to use both in the same referential integrity.

jg

--
@home.com is bogus.
FBI agents would abuse the tools at their discretion?  Horrors!
http://www.signonsandiego.com/uniontrib/20050125/news_1b25elgindy.html