Post reply

Partitioning Table with Page Level Compression on Data and Indexes without losing compression

  • January 11, 2017 at 8:57 am

    #333808

    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?

  • January 11, 2017 at 1:52 pm

    #1922063

    After doing some reading, it seemed to be a better idea to rename the original table and create a new table set up with PAGE compression using the desired partitions and copy the data into that table.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply