STUDY OF PERFORMANCE TUNING TECHNIQUES
Srushti Patil, Pooja Damare, Jagruti Sonawane, Neeta Maitre · Journal of Emerging Technologies and Innovative Research · 2015
In the modern era, digital data is considered as the more valuable asset of an organization, and the organizations assign more significance to it than the software and hardware assets. Database systems are computer-based record keeping systems, which have been developed to store data for efficient retrieval and processing. Since data is produced and shared every day, data volumes could be large enough for the database performance to become an issue. In order to maintain database performance, identification and diagnosis of the root causes that may cause delayed queries is done. Poor query design can be one of the major causes of delayed queries. There are various methods available to deal with the performance issues. Database administrator decides the method or combination of methods that work best. In this paper, we present some performance tuning techniques such as SQL Tuning, Indexing and Table Partitioning along with their advantages and limitations.