Comparative Analysis of Query Optimization Techniques in Database Systems
Pooja Wankhade
, Dr. Vaishali Deshmukh
optimization, database tuning, relational database, bulk-insert, execution time
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.
"Comparative Analysis of Query Optimization Techniques in Database Systems", IJSDR - International Journal of Scientific Development and Research (www.IJSDR.org), ISSN:2455-2631, Vol.4, Issue 3, page no.515 - 519, March-2019, Available :https://ijsdr.org/papers/IJSDR1903090.pdf
Volume 4
Issue 3,
March-2019
Pages : 515 - 519
Paper Reg. ID: IJSDR_190285
Published Paper Id: IJSDR1903090
Downloads: 000347271
Research Area: Engineering
Country: Pune, Maharashtra, India
ISSN: 2455-2631 | IMPACT FACTOR: 9.15 Calculated By Google Scholar | ESTD YEAR: 2016
An International Scholarly Open Access Journal, Peer-Reviewed, Refereed Journal Impact Factor 9.15 Calculate by Google Scholar and Semantic Scholar | AI-Powered Research Tool, Multidisciplinary, Monthly, Multilanguage Journal Indexing in All Major Database & Metadata, Citation Generator
Publisher: IJSDR(IJ Publication) Janvi Wave
