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 |
|
samurai_warrior
Starting Member
2 Posts |
 Posted - 2009-01-16 : 11:53:23
|
| Hi,We have a scenario where we have seperate table for each region and each table contains 10 million records. Totally 7 regions and tables.Now we have thought of combining it into one single table and partition the table based on region using list partitioning.So as of now the table will contain 70 million records after partitioning and it's expected to grow.Will this approach works and will there be any performance issue becuase of this new approach.Let me know your suggestionsThanks in advance. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-01-16 : 11:59:36
|
| nope. not any performance issues. you can even create indexes on partitions where queries fire frequently to speed up performance further. |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
samurai_warrior
Starting Member
2 Posts |
Posted - 2009-01-16 : 12:23:02
|
| Visakh, thanks for ur quick response. Will there not be a performance issue even the table grow for more than billion records and keep growing? |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-01-16 : 15:22:18
|
| Samurai_warrior,You need Enterprise Edition for Table Partitioning.You can archive old history to different partition with switch in/out.There is really good Whitepaper on it.Search for it. |
|
|
|
|
|
|
Reg: Table partitioning