Index Effect on Data Manipulation Toward Database Performance

Abstract

Database volume undergone an explosion due to intensive user and machine generated data. The volume growth slow down the processing speed. On the other hand the demand of real time information processing greatly desired. Therefore, speed up database processing becomes a key success factor for information processing. Indexing is a methods to provide a sorted order of data content and a pointer to the physical location where data is stored. Effective indexing lead to better searching performance. This research focus on the observation of the effect of index to the performance of Data Manipulation Language statement (DML) on huge amount of data in the database. According to the evaluation, the test results shows a statistically significant difference between indexed compare to non-indexed database in all DML statement.