Performance Analysis of SQL Server's Index
Youxue Zhou · 2007
It is one of the purpose to raise the efficiency of the retrieval which the designer and user chase .Using index can raise efficiency of the retrieval and guarantee the uniqueness of the database .Clustered index and nonclustered index are the two patterns index of the SQL SERVER 2000.Through investigating the definition and practice of the two type indexes,this paper researches the method and basic principle to raise the efficiency of the indexes without changing the pattern of the indexes.