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 |
|
sjohnson4532
Starting Member
4 Posts |
 Posted - 2012-01-04 : 18:12:33
|
| Can someone tell me if SQL Server maintains the order of an index across partitions? I am designing a database partitioned by monthand am concerned about the speed of record inserts over time if I keep a year's worth of data in the database. I've learned in the past that maintaining indexes can slow down record inserts as a table grows.Any help would be much appreciated. |
|
|
Bustaz Kool
Master Smack Fu Yak Hacker
1834 Posts |
Posted - 2012-01-04 : 19:09:26
|
| Yes, the order is maintained. Partitioning changes the PHYSICAL layout of the data but does not impact the LOGICAL ordering. Since the data in each partition is relatively small, the B-tree for each partition is correspondingly shallower which should make the inserts slightly faster. The amount of page splits would be the determining factor though. For SELECTing data, however, a query that filtered on the partitioning columns would allow the SQL search engine to ignore the unneeded partitions which should increase performance.=================================================Men shout to avoid listening to one another. -Miguel de Unamuno |
 |
|
|
|
|
|
Partitioning Newbie (Please Help)