期刊名称：International Journal of Advanced Computer Research
印刷版ISSN：2249-7277
电子版ISSN：2277-7970
出版年度：2015
卷号：5
期号：19
页码：205-211
出版社：Association of Computer Communication Education for National Triumph (ACCENT)
摘要：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.
关键词：Database statistics; plan table records; cost retrieval; cardinality retrieval; bytes retrieval; optimization of cost; cost comparison; simplex.
