SQL Server索引的优化

Optimization of SQL Server Index

SQLServer优化技术对提高系统性能至关重要 .为充分利用索引 ,优化表的查询机制 ,从而提高SQLServer查询速度 ,本文从建立有用的索引减少表扫描I O次数 ,优化WHERE子句避免列操作 。

SQL Server optimizing technique is very important to improve system performance.The problem is how to make full use of index,to optimize the query mechanism of table,so as to increase SQL server query speed.This paper expounds following four points:first,establish useful index to reduce percent times of table scan;secondly,optimize WHERE clauses to avoid the operation of line;thirdly,make full use of multiplex index to choose the first index line,and last,make use of assemble index to let the data be lined in physical order.