ResearchBib Share Your Research, Maximize Your Social Impacts
Sign for Notice Everyday Sign up >> Login

A Simplistic Mechanism for Query Cost Optimization

Journal: International Journal of Advanced Computer Research (IJACR) (Vol.5, No. 19)

Publication Date:

Authors : ; ; ; ;

Page : 205-211

Keywords : Database statistics; plan table records; cost retrieval; cardinality retrieval; bytes retrieval; optimization of cost; cost comparison; simplex.;

Source : Downloadexternal Find it from : Google Scholarexternal


The cost of a database query can be optimized so that a more efficient query can be generated. However not many tools are available which work independently to optimize the cost of a query. This article is based on a tool that we developed to serve the purpose. It uses an Oracle Database and Linear Programming Problem concepts to evaluate the optimum cost of the query and compares it with the original cost of the query that the user gives. The optimum cost can also be used to devise a new query which serves the same purpose as the original one and with reduced cost.

Last modified: 2015-06-26 20:34:16