A Simplistic Mechanism for Query Cost Optimization
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.
Keyword
Database statistics, plan table records, cost retrieval, cardinality retrieval, bytes retrieval, optimization of cost, cost comparison, simplex.