I need to partition a large table that already has page level compression on data and indexes. I have set up the partition scheme and have all of the file groups defined.
My plan is to:
1. drop all indexes except for the clustered index
2. recreate the clustered index with DROP EXISTING=ON using the partition scheme and DATA_COMPRESSION = PAGE
3. recreate all other indexes with DATA_COMPRESSION = PAGE
My question is this:
Will the table data remain compressed when I move to the partitioned structure?