Query Optimization Methods and Techniques on Production Database Server

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: tarandeepskhs@gmail.com

Received:
27 feb 2018

Accepted:
25 Apr 2018

Online Published:
18 Jun 2018

How to cite the Article

This image has an empty alt attribute; its file name is images.png
View on Google Scholar

ABSTRACT

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.

Keywords

TKPROF, RBO, CBO, INDEX, TRACE SQL.