Optimization of SQL Server Index
W. Yuan · 2001
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.