The Impact of Table and Index Compression

The amount of stored data is growing rapidly, and it brings considerable challenges. The enormous growth in the volume of data makes storage one of the biggest cost elements. For this purpose, relational databases are used very often. Fast access to data is becoming increasingly important and great emphasis is placed on its improvement. This paper deals with the impact of table and index compression on data access time and CPU costs, which is compared in nine different scenarios of different combinations of compressed and uncompressed indexes over compressed and uncompressed tables of various row numbers.