Determining Table Compression
Is there a way to see if a table/partition/etc is actually compressed or not?
If an alter table compress statement has been run but the alter table move compress has not, is there anyway to tell that the table really isn't compressed? Or if a table has been accidently uncompressed by use of an update statement - how do I determine if it's actually uncompressed?
Thanks
If an alter table compress statement has been run but the alter table move compress has not, is there anyway to tell that the table really isn't compressed? Or if a table has been accidently uncompressed by use of an update statement - how do I determine if it's actually uncompressed?
Thanks
1