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.
| Author |
Topic |
|
barhamgi
Starting Member
7 Posts |
 Posted - 2008-04-08 : 10:18:06
|
| hello i want to ask if the insertion of a record into a partion is slower than insertion it into a non partitioned table or not?cuz sql has to decide to wich partion the record has to insert according to the partitioning key and is this decesion process is making insertion slower ? |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-04-08 : 10:20:58
|
It is somewhat slower, because the engine has to decide which partition to insert into.The time is however negligable.
E 12°55'05.25"N 56°04'39.16" |
 |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-04-08 : 10:31:27
|
| But you have advantage while selecting as your data will be stored in correct partition. |
|
|
|
|
|
|
insertion into partitioned table