Performance Analysis of Query Optimizers under Varying Hardware Components in RDBMS

Performance Analysis of Query Optimizers under Varying Hardware Components in RDBMS

Query Optimization is the process of choosing the most efficient way to execute a Structured Query Language (SQL) statement, while query optimizer is a tool in Relational Database Management System (RDBMS) that carries out the process of optimizing a query. In this paper, four different RDBMS were considered namely Microsoft SQL 2010 Server, Oracle 11g Release 2, My SQL 5.6 and Microsoft Access 2010. For the purpose of testing four different data sets were used. The data was run using each data set (1 310 116, 1 047 999, 750 000, 500 000, 250 000 and 125 000). It was discovered that adding more memory to the system shows improved performance of the RDBMS query optimizer. Also, increasing Hard Disk Size has little effect on the performance of RDBMS. While changing the processor size from single core to duo core does not visibly show improved performance of the RDBMS. In all the cases stated, SQL Server 2010 offers better performance followed by My SQL 5.6, Oracle 11g release 2 and Ms Access 2010 respectively. Therefore this paper provides a framework to monitor the trend of the increasing/decreasing changes in hardware components on the performance of query optimizers in RDBMS. The application is recommended for RDBMS developers and maintainers.