Post reply

table partitioning

  • January 10, 2013 at 11:36 am

    #287463

    Hi Experts,

    Can we use same partition scheme and partition function for different tables in same schema ?

    I got 5 large tables to be partitioned in a specific schema in a database, i used a partition function and scheme for the first tabled can i use it for remainning 4 tables, i am partitioning the table on a column called check_key, do i need to have same columna in all five tables in order to use same partition scheme and function or do i need to create a seperate new scheme and function for each table(5 tables)

    please help

  • January 10, 2013 at 11:52 am

    #1575915

    yes, providing all the tables have the same column. Not sure it's necessarily a good idea, but you can do it.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

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

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