Full Paper View Go Back
Improving Effectiveness of Query Optimizer
Jyoti Haweliya1 , Ravinder Kaur Narang2
Section:Technical Paper, Product Type: Isroset-Journal
Vol.2 ,
Issue.1 , pp.11-11, Jan-2014
Online published on Feb 28, 2014
Copyright © Jyoti Haweliya, Ravinder Kaur Narang . This is an open access article distributed under the Creative Commons Attribution License, which permits unrestricted use, distribution, and reproduction in any medium, provided the original work is properly cited.
View this paper at Google Scholar | DPI Digital Library
How to Cite this Paper
- IEEE Citation
- MLA Citation
- APA Citation
- BibTex Citation
- RIS Citation
IEEE Style Citation: Jyoti Haweliya, Ravinder Kaur Narang, “Improving Effectiveness of Query Optimizer,” International Journal of Scientific Research in Computer Science and Engineering, Vol.2, Issue.1, pp.11-11, 2014.
MLA Style Citation: Jyoti Haweliya, Ravinder Kaur Narang "Improving Effectiveness of Query Optimizer." International Journal of Scientific Research in Computer Science and Engineering 2.1 (2014): 11-11.
APA Style Citation: Jyoti Haweliya, Ravinder Kaur Narang, (2014). Improving Effectiveness of Query Optimizer. International Journal of Scientific Research in Computer Science and Engineering, 2(1), 11-11.
BibTex Style Citation:
@article{Haweliya_2014,
author = {Jyoti Haweliya, Ravinder Kaur Narang},
title = {Improving Effectiveness of Query Optimizer},
journal = {International Journal of Scientific Research in Computer Science and Engineering},
issue_date = {1 2014},
volume = {2},
Issue = {1},
month = {1},
year = {2014},
issn = {2347-2693},
pages = {11-11},
url = {https://www.isroset.org/journal/IJSRCSE/full_paper_view.php?paper_id=127},
publisher = {IJCSE, Indore, INDIA},
}
RIS Style Citation:
TY - JOUR
UR - https://www.isroset.org/journal/IJSRCSE/full_paper_view.php?paper_id=127
TI - Improving Effectiveness of Query Optimizer
T2 - International Journal of Scientific Research in Computer Science and Engineering
AU - Jyoti Haweliya, Ravinder Kaur Narang
PY - 2014
DA - 2014/02/28
PB - IJCSE, Indore, INDIA
SP - 11-11
IS - 1
VL - 2
SN - 2347-2693
ER -
3443 Views
3360 Downloads
3269 Downloads
Abstract :
Query Optimization is important tasks in Relational DBMS. Given a query, there are many plans that a database management system (DBMS) can follow to process it and produce its answer. All plans are equivalent in terms of their final output but vary in their cost, i.e., the amount of time that they need to run. Process of finding good evaluation plan is called Query Optimization .The plan is formed from different combination of operators and the way these operators are implemented in database affects the cost of query. However, the literature do not attempt to give us comparison of different implementation algorithms for operators and to what particular type of plan a Query Optimizer should select for a particular situation. Therefore it is the purpose of this paper to understand and develop a comparison among them by taking example of a simple query. Further on basis of our analysis, we found some proposals that will help Query Optimizer to rule out good plans from bad plans in effect improving effectiveness of Query Optimizer.
Key-Words / Index Term :
Query Optimizer, Prefer Pipelining, Sequential Access
References :
[1]. Johann Christopher Freytag, ”Basic Principles of Query Optimization”, March 1989/09, CA, pp 801-807.
[2]. Yannis E. Ioannidis, University of Wisconsin, “Query Optimization”, June 1982.
[3]. Visshy Posala, Bell Labs, Query Optimization, April 1992
[4]. S. Mein, “Principles of Query Optimization”, 1990.
[5]. L. Vieille , “Advanced Query Optimization”, March 1989
[6]. C. White., Principles of Semantic Query , 1986
[7]. G.von Bultz, Translating and Optimizing Global Queries, 1987
[8]. W. Wang , Optimizing Dynamic AND Parametric Queries, 1985
[9]. Ram Krishnan and Gehrek, Introduction to Relational Database
[10]. Silberschatz, Korth, Sudarshan, Introduction to Database concepts.
You do not have rights to view the full text article.
Please contact administration for subscription to Journal or individual article.
Mail us at support@isroset.org or view contact page for more details.
