SQL Server2005大型数据库优化之表分区详解[J]. 云南大学学报(自然科学版), 2013, 35(S2): 59. doi: 10.7540/j.ynu.2013b14
引用本文: SQL Server2005大型数据库优化之表分区详解[J]. 云南大学学报(自然科学版), 2013, 35(S2): 59. doi: 10.7540/j.ynu.2013b14
The detailed optimization in table partition of the SQL Server2005 large database[J]. Journal of Yunnan University: Natural Sciences Edition, 2013, 35(S2): 59. DOI: 10.7540/j.ynu.2013b14
Citation: The detailed optimization in table partition of the SQL Server2005 large database[J]. Journal of Yunnan University: Natural Sciences Edition, 2013, 35(S2): 59. DOI: 10.7540/j.ynu.2013b14

SQL Server2005大型数据库优化之表分区详解

The detailed optimization in table partition of the SQL Server2005 large database

  • 摘要: 作者阐述了大型数据库表分区的原理,并探讨了如何在已经长期运行的数据库上实现表分区.大型数据库因为数据量日益增大造成性能低下,通过表分区可以大幅度的优化数据库,并对原有数据无任何影响.

     

    Abstract: This article describes the principle of a large database table partitions,and explores how to realize table partition on the long-running database. Because large databases will be poor performance result in the increasing amount of data,partitioning the table can greatly optimizes the database,and has no effect on the original data.

     

/

返回文章
返回