Shrink Table and Compression
614748Jun 9 2008 — edited Jun 9 2008I have a table with compression turned on. The developers deleted 75% of the data in the table. So I would like bring the HWM to the correct level. I would like to use the shrink operation because it is very easy, online and doesn't invalidate indexes. However the shrink operation will not work against compressed tables. So I can Alter table nocompress and then issue the shrink command and it will work like a champ, and I can then turn on compression again. However the piece I am unsure of is after the shrink operation does the data that was still in the table become uncompressed?
I know that altering a table with compress or nocompress will not do anything to existing data but if the flag changes and then a shrink operation occurs will that affect the data in terms of compression?
Any insight is appreciated.