INTERNATIONAL JOURNAL OF SCIENTIFIC DEVELOPMENT AND RESEARCH International Peer Reviewed & Refereed Journals, Open Access Journal ISSN Approved Journal No: 2455-2631 | Impact factor: 8.15 | ESTD Year: 2016
open access , Peer-reviewed, and Refereed Journals, Impact factor 8.15
Comparative Analysis of Query Optimization Techniques in Database Systems
Authors Name:
Pooja Wankhade
, Dr. Vaishali Deshmukh
Unique Id:
IJSDR1903090
Published In:
Volume 4 Issue 3, March-2019
Abstract:
Due to huge growing data, performance of database systems is now critical for every organization. There exist several bottlenecks affecting this performance like memory, processor, network issues, etc. Out of these, query optimization exhibits major role in database optimization and contributes to almost 70% of database tuning [1]. Queries can be written in many different ways to achieve same set of results. Query optimization refers to various query rewriting techniques to achieve results faster. There is a need to rewrite non-optimal queries to get the same correct result in minimum possible time. This paper discusses about some of the query optimization techniques that can be used to achieve results from database in lesser time. In this paper, we have compared different query optimization techniques in terms of execution time. These optimized strategies yields the same result from database in minimum possible time.
Keywords:
optimization, database tuning, relational database, bulk-insert, execution time
Cite Article:
"Comparative Analysis of Query Optimization Techniques in Database Systems", International Journal of Science & Engineering Development Research (www.ijsdr.org), ISSN:2455-2631, Vol.4, Issue 3, page no.515 - 519, March-2019, Available :http://www.ijsdr.org/papers/IJSDR1903090.pdf
Downloads:
000337064
Publication Details:
Published Paper ID: IJSDR1903090
Registration ID:190285
Published In: Volume 4 Issue 3, March-2019
DOI (Digital Object Identifier):
Page No: 515 - 519
Publisher: IJSDR | www.ijsdr.org
ISSN Number: 2455-2631
Facebook Twitter Instagram LinkedIn