The only issue I experienced with compression is on 10.2.0.3 on windows where dates in a compressed table are not found when queried whether they use an index or not. Ken _____ From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Ben Wittmeier Sent: Wednesday, July 23, 2008 5:39 PM To: oracle-l Subject: Table compression experience? Does anyone have any negative experiences in using table compression? The following link is what we have on it: <http://www.oracle.com/technology/products/bi/db/10g/pdf/twp_data_compressio n_10gr2_0505.pdf> http://www.oracle.com/technology/products/bi/db/10g/pdf/twp_data_compression _10gr2_0505.pdf Any of you guys have any warnings on its use? Thanks, Ben This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail.