首页>
外国专利>
Method and Plan Optimizing Apparatus for Optimizing Query Execution Plan
Method and Plan Optimizing Apparatus for Optimizing Query Execution Plan
展开▼
机译:用于优化查询执行计划的方法和计划优化设备
展开▼
页面导航
摘要
著录项
相似文献
摘要
A method for optimizing query execution comprises receiving one or more optimizing parameters from a user device for optimizing a query execution plan. The one or more optimizing parameters comprise at least one of a query statement, a planning time and a plan execution time. The one or more optimizing parameters are received when duration of execution of the one or more queries using the query execution plan is greater than a predefined time period required for executing the one or more queries. The query execution plan is latest of one or more query execution plans for executing one or more queries. The method comprises generating an optimized query execution plan by iterating optimization of the query execution plan until the optimization satisfies the one or more optimizing parameters.
展开▼