Increasing Database Performance using Indexes

Cecilia Cioloca () and Mihai Georgescu ()
Additional contact information
Cecilia Cioloca: Academy of Economic Studies, Bucharest
Mihai Georgescu: Academy of Economic Studies, Bucharest

Database Systems Journal, 2011, vol. 2, issue 2, 13-22

Abstract: 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.

Keywords: Clustered index; Nonclustered index; Optimization; Database; Performance (search for similar items in EconPapers)
Date: 2011
References: View complete reference list from CitEc
Citations:

Downloads: (external link)
http://dbjournal.ro/archive/4/2_Ciologa_Georgescu.pdf (application/pdf)

Related works:
This item may be available elsewhere in EconPapers: Search for items with the same title.

Export reference: BibTeX RIS (EndNote, ProCite, RefMan) HTML/Text

Persistent link: https://EconPapers.repec.org/RePEc:aes:dbjour:v:2:y:2011:i:2:p:13-22

Access Statistics for this article

Database Systems Journal is currently edited by Ion Lungu

More articles in Database Systems Journal from Academy of Economic Studies - Bucharest, Romania Contact information at EDIRC.
Bibliographic data for series maintained by Adela Bara ().