摘要
SQL Server作为一种企业级的数据库,提供了丰富的特性,开发者可以从多个角度进行性能分析与优化。特别是聚集索引非常关键,而一个表只能有一个聚集索引,应该合理应用。同时要善于利用数据库系统提供的各种工具,有针对性地分析和调校性能。实践表明,只要适当进行优化,在普通服务器平台上,SQL大数据量数据库的性能是基本可用的。
As an enterprise-class database,SQL server possesses many functions.Developers may conduct performance analysis and optimization.In particular,as a table can have only one clustered index,the clustered index is critical and should be applied reasonably.At the same time developers must be good at using different database tools to analyze and adjust performance.Practice shows that the performance of mass data SQR database is reliable through proper optimization in a general platform.
出处
《武汉船舶职业技术学院学报》
2010年第1期27-30,35,共5页
Journal of Wuhan Institute of Shipbuilding Technology
关键词
海量数据
优化
索引
聚集索引
mass data
optimization
index
clustered index
