The effect of horizontal database table partitioning on query performance

----------------------------------------------------------------------------------------------------------------------------------The need for achieving optimal performance for database applications is a primary objective for database designers and a primary requirement for database end users. Partitioning is one of the techniques used by designers to improve the performance of database access. The purpose of this study was to investigate the effect of horizontal table partitioning on query response time using three partitioning strategies: zero partitioning, list partitioning and range partitioning. Three tables extracted from the Student Information System (SIS) at Yarmouk University in Jordan were used in this research. Variation in table size was used to determine when partitioning can have an impact (if any) on access performance. A set of 12 queries were run over a database of three different sizes. The results indicated that partitioning provided better response time than zero ...

• Type: Journal
• Year: 2016
• Where: IAJIT
• Authors: Salam Matalqa, Suleiman Mustafa
• Keywords: Biometrics, IAJIT 2016