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.