Home Forums Data Warehousing Strategies and Ideas Can you create a partition on an existing Fact table? RE: Can you create a partition on an existing Fact table?

  • May 14, 2014 at 1:17 pm

    #1713594

    GilaMonster (5/14/2014)

    You can partition an existing table. Not by adding partitions to it, but by rebuilding the clustered index onto a partition scheme. This will take as long as rebuilding the clustered index usually takes, it won't be instant.

    Once partitioned, you can switch out a partition of data (swap a partition with an empty table) to do fast 'deletes'

    Thanks for the response GilaMonster. Would you by any chance know of any article that could help me through this process? I have read about creating the partition function and scheme.

    When rebuilding the clustered index, I can just delete it and rebuild it so it is pointing to the newly created partition scheme?

    As for switching out a partition of data (which sounds like that is what I am ultimately looking for) I dont know anything about this. Any info would be greatly appreciated.

    Thanks