Post reply

Can we have same Partition function and Partition Scheme to all the tables in a schema ?

  • January 8, 2013 at 10:28 am

    #268595

    Can we use same Partition function and Partition Scheme to all the tables in a schema ?

  • January 9, 2013 at 1:41 am

    #1575096

    You can. Whether it's a good idea or not, only you can tell that.

    Partitioning is something that must be tested thoroughly before implementing.

    If the partitioning key is not used frequently in your queries, the overall performance could get worse than what you get on the non-partitioned tables.

    -- Gianluca Sartori

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

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