首页>
外国专利>
Method, system, and program for performance tuning a database query
Method, system, and program for performance tuning a database query
展开▼
机译:用于性能调优数据库查询的方法,系统和程序
展开▼
页面导航
摘要
著录项
相似文献
摘要
Provided are a method, system, an program for tuning a database query. Provided are a base access plan to implement the database query and statistics including information on a layout of the database against which the query will be executed. The statistics are processed to determine performance problems with the base access plan as part of a first analysis of the base access plan and the determined performance problems are processed as part of a second analysis to provide an analysis of the determined performance problems and processing cost of the base access plan. Recommendations are generated to tune the base access plan to improve performance.
展开▼