(Publisher of Peer Reviewed Open Access Journals)

International Journal of Advanced Computer Research (IJACR)

ISSN (Print):2249-7277    ISSN (Online):2277-7970
Volume-5 Issue-19 June-2015
Full-Text PDF
Paper Title : A Simplistic Mechanism for Query Cost Optimization
Author Name : Debopam De, Deblina Banerjee, Sneha Mukherjee and Jayati Ghosh Dastidar
Abstract :

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.

Keywords : Database statistics, plan table records, cost retrieval, cardinality retrieval, bytes retrieval, optimization of cost, cost comparison, simplex.
Cite this article : Debopam De, Deblina Banerjee, Sneha Mukherjee and Jayati Ghosh Dastidar, " A Simplistic Mechanism for Query Cost Optimization " , International Journal of Advanced Computer Research (IJACR), Volume-5, Issue-19, June-2015 ,pp.205-211.