Distinct Partition Functions?

• senthil kumar d

  Old Hand

  Points: 395

  More actions

  July 29, 2014 at 5:41 am

  #288584

  Hi All

  We are planning to partition some of the huge tables that we have which hold records in the magnitude of billions.. The design is to perform monthly partitions.. Do you think it is sensible to have distinct partition functions for each table even though they are going to be defined on the same monthly ranges.. I think it is a safe option even though we have to create a lot of partition functions but the main positive from this approach is that when we perform maintenance on the partitions like Merge/Split each of the tables is isolated so the risk of data movement in case of partition maintenance failure is isolated at the table level rather than 100s of tables using the same partition function and if one of the tables have to be split(may be extreme scenario) it would be handled only on that particular table level.

  Regards

  Senthil