首页>
外国专利>
Method and apparatus for analyzing the effect of different execution parameters on the performance of a database query
Method and apparatus for analyzing the effect of different execution parameters on the performance of a database query
展开▼
机译:分析不同执行参数对数据库查询性能的影响的方法和装置
展开▼
页面导航
摘要
著录项
相似文献
摘要
A database application re-uses one or more query execution strategies for a given logical query, and saves historical data concerning query execution performance under differing execution parameters. The historical data is analyzed to identify environmental variables and/or imported variables which significantly affect execution performance. Preferably, an auxiliary data structure includes, for each of multiple execution strategies, a respective set of imported and environmental variables and respective average cost measure, such as execution time. An analytical tool compares multiple different strategies to identify imported and/or environmental variables which caused a different strategy to be used, and resultant average cost. Preferably, the tool can also compare variation within the same strategy.
展开▼