SQL表分区 [英] SQL Table Partitioning

问题描述

大家好.
正在使用sqlserver 2008 R2

我有一些表，这些表中的数据增加了2千万加仑，将来会增加.由于我的数据库性能变得非常慢，我集中精力进行索引甚至查询优化.还是我们遇到了同样的问题.


所以我想使用分区技术来克服这个问题.

我怀疑很少有表在are子句中使用主键，而在某些表中在where子句中使用forgien键.

任何人都可以建议我们是否要对需要选择的列进行分区.

附言:我在数据库中的所有数据都是已迁移的数据库.

谢谢
karthik

hi every one.
am using sqlserver 2008 R2

i have a few tables with data in those tables increased by 2 crores pluse ,in future it hits more.by that my database performace became very slow, i concentrated on indexing and even on query optimization. still we hitting the same problem.


so i want to use partition technic to overcome this.

i have a doubt for few table am using primary key in were clause and in some table forgien key in where clause.

can any one please suggest if at all we go for partitioning on which columns we need to select .

P.s : all my data in data base is migrated data base.

thanks
karthik

推荐答案

你好

也许有帮助:
下载"使用SQL Server 2008的分区表和索引策略''白皮书

Hello

Maybe it helps:
Download ''Partitioned Table and Index Strategies Using SQL Server 2008'' white paper

这篇关于SQL表分区的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！