Re: COMPRESS engine

2004-10-06 Thread Richard Jacobsen
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? > > It won't speed up seeks, but it will increase the chances that two > nearby records are on the s

Re: COMPRESS engine

2004-10-06 Thread Dan Nelson
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 obviously all table space doesn't > fit in memory, Will using the compress engine speed reads/seeks on > these tab

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 considerabl