Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 Insert into Table Partitioning

Author  Topic 

sent_sara
Constraint Violating Yak Guru

377 Posts

Posted - 2013-08-02 : 14:30:39
Hi,
Just Analysing the Performance for insertion of 2 million records into partioning and non-partitioning table.

In partitioning Table it took long time to insert when compare to non partitioning. can i know what is the process behind goes
while inserting rows into partioning table?

MuMu88
Aged Yak Warrior

549 Posts

Posted - 2013-08-02 : 19:54:34
As per BOL:
"Partition function
A database object that defines how the rows of a table or index are mapped to a set of partitions based on the values of certain column, called a partitioning column. That is, the partition function defines the number of partitions that the table will have and how the boundaries of the partitions are defined. For example, given a table that contains sales order data, you may want to partition the table into twelve (monthly) partitions based on a datetime column such as a sales date."

You can read more here:
http://msdn.microsoft.com/en-us/library/ms190787.aspx
Go to Top of Page
   

- Advertisement -