An Appraisal to Optimize SQL Queries

Performance engineering is a vital aspect in the SQL statement crafting. SQL is a non-procedural language and gives the wrong impression that the form of the SQL statement does not matter provided it produces the accurate result set. Statements which are not cautiously designed can instigate massive performance issues. There subsists many ways of writing SQL statement to retrieve same result set, but the one which imposes minimum impact on DBMS engine is always esteemed. The proposed model is intended to serve as benchmark for the tuning SQL queries and thus improving Query performance. This paper enunciates sundry techniques that can serve as an SQL Tuning tool for programmers. Our analysis ensured reduction in time and space complexity.