Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Can we have same Partition function and Partition Scheme to all the tables in a schema ? Expand / Collapse
Author
Message
Posted Tuesday, January 8, 2013 10:28 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: 2 days ago @ 12:35 PM
Points: 235, Visits: 975
Can we use same Partition function and Partition Scheme to all the tables in a schema ?
Post #1404372
Posted Wednesday, January 9, 2013 1:41 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Wednesday, July 23, 2014 4:31 AM
Points: 5,014, Visits: 10,514
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

Get your two-cent-answer quickly
spaghettidba.com
@spaghettidba
Post #1404598
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse