UGC Approved Journal no 63975

ISSN: 2349-5162 | ESTD Year : 2014
Call for Paper
Volume 10 | Issue 2 | February 2023

JETIREXPLORE- Search Thousands of research papers



WhatsApp Contact
Click Here

Published in:

Volume 2 Issue 3
March-2015
eISSN: 2349-5162

UGC and ISSN approved 7.95 impact factor UGC Approved Journal no 63975

7.95 impact factor calculated by Google scholar

Unique Identifier

Published Paper ID:
JETIR1503018


Registration ID:
150148

Page Number

499-502

Share This Article


Jetir RMS

Title

STUDY OF PERFORMANCE TUNING TECHNIQUES

Abstract

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.

Key Words

Database performance, Tuning, Index, Optimization, QEP(Query Execution Plan).

Cite This Article

"STUDY OF PERFORMANCE TUNING TECHNIQUES", International Journal of Emerging Technologies and Innovative Research (www.jetir.org), ISSN:2349-5162, Vol.2, Issue 3, page no.499-502, March-2015, Available :http://www.jetir.org/papers/JETIR1503018.pdf

ISSN


2349-5162 | Impact Factor 7.95 Calculate by Google Scholar

An International Scholarly Open Access Journal, Peer-Reviewed, Refereed Journal Impact Factor 7.95 Calculate by Google Scholar and Semantic Scholar | AI-Powered Research Tool, Multidisciplinary, Monthly, Multilanguage Journal Indexing in All Major Database & Metadata, Citation Generator

Cite This Article

"STUDY OF PERFORMANCE TUNING TECHNIQUES", International Journal of Emerging Technologies and Innovative Research (www.jetir.org | UGC and issn Approved), ISSN:2349-5162, Vol.2, Issue 3, page no. pp499-502, March-2015, Available at : http://www.jetir.org/papers/JETIR1503018.pdf

Publication Details

Published Paper ID: JETIR1503018
Registration ID: 150148
Published In: Volume 2 | Issue 3 | Year March-2015
DOI (Digital Object Identifier):
Page No: 499-502
Country: Pune, Maharashtra, India .
Area: Engineering
ISSN Number: 2349-5162
Publisher: IJ Publication


Preview This Article


Downlaod

Click here for Article Preview

Download PDF

Downloads

0003033

Print This Page

Current Call For Paper

Jetir RMS