SQL Server索引技术  

On Index Techniques of SQL Server

作　　者：董佑平[1] 彭渤[2] 

机构地区：[1]山东交通学院信息工程系,山东济南250023 [2]天同证券公司电脑部,山东济南250011

出　　处：《山东交通学院学报》2004年第1期68-70,83,共4页Journal of Shandong Jiaotong University

摘　　要：提高SQLServer性能的方法很多,其中索引是决定数据库性能的重要因素。SQLServer中有两种索引技术:聚簇索引和非聚簇索引。充分分析聚簇索引和非聚簇索引的体系结构及适用情况,建立最佳的索引,并且在创建索引时指定合适的填充因子可以提高数据库的性能。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.

关 键 词：系统访问数据库 SQL Server索引技术 聚簇索引 非聚簇索引 填充因子 

分 类 号：TP311.138[自动化与计算机技术—计算机软件与理论]