Tuning SQL Queries for Better Performance in Management Information Systems Using Large Set of Data
Ion Lungu, Adela Bârã · SSRN Electronic Journal · 2007
In order to improve the quality of Management nformation Systems in an organization we can choose to build the system using Business Intelligence techniques such as OLAP and datawarehousing or by using traditional reports based on SQL queries. The cost and developing time for BI tools is greater than those for SQL Reports and these factors are important in taking decission on what type of techniques we used for MIS. This paper presents some of the optimization methods that are used for better performance and low time response SQL queries.