Sam,

<< I guess if the table is encrypted then there is no savings in using
compression, correct? >>

No.  Steve is correct - the compression occurs prior to the encryption.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim Young [Elevate Software] wrote:

> Sam,
>
> << I guess if the table is encrypted then there is no savings in using
> compression, correct? >>
>
> No.  Steve is correct - the compression occurs prior to the encryption.
>

Tim & Steve,
   Great, thanks. I changed it to compression today because I'm storing a
lot of text data (3k-5k) per record. It makes quite a difference in
space saving with no speed reduction in fulltext searching. Cool!

Sam