Implementation of Decomposition Technique in Select Query Statements

Abstract

SQL code tuning is a vital concern when dealing with large amount of data which makes retrieving of records in a database challenging. Database administrators and programmers tried to analyze and speed up their query statements to meet the tolerable waiting time of the users and for the applications to produce efficient and timely results. Data warehousing technique is used to lessen the execution time of the query. The Stackoverflow Benchmark database was utilized with the goal of facilitating performance of the commonly used SQL Read Statements with Select, Join and Union Set Operator. The experiment was limited to a single PC with SQL Server installed. The developed method was able to improve the performance of the query as the effect of the modification when implemented using the decomposition technique and extracting columns by nature inspired crow search algorithm for each Read SQL Statements.