Hi

Did the table(s) that you did compression had any XML datatype columns in it?

I am been doing some prototype where I see that compression does saves a lot of space, but only when there is no XML column.

When a table have a XML column in it as major contributor to table size, the compression does not show any significant savings in data space.

Just wanted to know you if you had any such scenario of XML columns in your tables?

Thanks