On Index Techniques of SQL Server
Dong You-ping · Journal of Jinan Communications College · 2004
There are many ways to increase the performance of SQL Server,among which indexes are the key factor to determine the performance of databank.There are two types of index techniques:clustered indexes and nonclustered indexes.This paper thoroughly analyzes the architecture and applied circumstances of the clustered indexes and nonclustered indexes and builds the best indexes.What is more,when the indexes are established,the appropriate fill factor will be named to increase the performance of databank.