Gyan Management Journal Year: 2018(Jan-Jun), Volume: (12), Issue. (1) First page: (45) Last page: (52) Online ISSN: A/F Print ISSN: 2250-348X doi:
Query Optimization Methods and Techniques on Production Database Server
Tarandeep Singh1,Dr. Sanjay Prakash Sood2And Dr. Harbax Singh Bhatti3
1Research Scholar, IKGPTU, Punjab & Asst. Prof., GJIMT, Mohali
2Joint Director, Centre for Development of Advanced Computing (CDAC), Mohali, Punjab
3Department of Applied Sciences, Baba Banda Singh Bahadur, Engineering College, Fatehgarh Sahib, Punjab
Corresponding author email id: firstname.lastname@example.org
27 feb 2018
25 Apr 2018
18 Jun 2018
How to cite the Article
We put forward a come close toward for query optimization on production server database by reducing weight and load, as an important skill for developers and database administrators (DBAs). In order to optimize the query and get the considered necessary outputs within time limits developer and DBA must understand the query optimization techniques. In today’s working, query optimization provides level-headed approach for extracting reports for pronouncement making for any organization. In the very foundation of the project when there is not much data in database the reports are unproblematic to fetch. When the data starts ever-increasing and we need reports for long episode of time within time limit then we may have to optimize the existing queries.
TKPROF, RBO, CBO, INDEX, TRACE SQL.