文章基本信息

标题：Increasing Database Performance using Indexes
本地全文：下载
作者：Cecilia CIOLOCA ; Mihai GEORGESCU
期刊名称：Database Systems Journal
电子版ISSN：2069-3230
出版年度：2011
卷号：II
期号：2
页码：13-22
出版社：Bucharest Academy of Economic Studies Publishing House
摘要：The performance issues are presented. The process of performance tuning is described. The indexing concept is introduced. The two types of defining an index are identified. The paper presents and explains the way a clustered and nonclustered index works. A compared analysis between clustered and nonclustered indexes is created. The benefits of using indexes on databases are identified and explained. A demonstration of using SEEK and SCAN indexes is presented, showing the logic behind these two types of indexes. Cases when an index must be used and how this index is created, are presented along with the performance improvement that is obtained after successfully creating the index.
关键词：Clustered index; Nonclustered index; Optimization; Database; Performance.