Welcome to IJSDR

IJSDR

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

Submit Paper Online

Call For Paper

Issue: April 2024

Volume 9 | Issue 4

Impact factor: 8.15

Click Here For more Info

Imp Links for Author

Imp Links for Reviewer

Research Area

Subscribe IJSDR

Visitor Counter

Indexing Partner

Published Paper Details

Paper Title:	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

Click Here to Download This Article

Article Preview
Click here for Article Preview

Major Indexing from www.ijsdr.org

Google Scholar	ResearcherID Thomson Reuters	Mendeley : reference manager	Academia.edu
arXiv.org : cornell university library	Research Gate	CiteSeerX	DOAJ : Directory of Open Access Journals
DRJI	Index Copernicus International	Scribd	DocStoc

Track Paper

Track Submitted Paper

Important Links

Call For Paper

Join As Reviewer

Conference Proposal

CLICK HERE
For Conference Prposal

ISSN

DOI (A digital object identifier)

Providing A digital object identifier by DOI
How to GET DOI and Hard Copy Related

Open Access License Policy

This work is licensed under a Creative Commons Attribution-NonCommercial 4.0 International License Creative Commons License

Social Media

IJSDR

Indexing Partner

For Authors Sample Paper Format Submit Paper Online Call For Paper Copyright Form Undetaking Form Publication Charges FAQ Contact US	Publications Current Issue Past Issue	Proposals Join As a Reviewer Editiorial Board Join in RMS Program Conference Proposal	Policies Privacy Policy Payment Terms and Condition Copyright Infringement Claims Payment Refund Policy
Copyright © 2024 - All Rights Reserved - IJSDR