Re: COMPRESS engine

2004-10-06 Thread Richard Jacobsen
Thanks, I'll give it at try. Richard On Wed, Oct 06, 2004 at 05:14:01PM -0500, Dan Nelson wrote: > In the last episode (Oct 06), Richard Jacobsen said: > > I've got some large tables, ~160GB each with indexes, which are only > > used for read only access. Since

COMPRESS engine

2004-10-06 Thread Richard Jacobsen
Hi everyone, I've got some large tables, ~160GB each with indexes, which are only used for read only access. Since obviously all table space doesn't fit in memory, Will using the compress engine speed reads/seeks on these tables up at all, or will they slow them down considerably? Thanks, Rich