发明申请
US20120005189A1 TECHNIQUES FOR RECOMMENDING ALTERNATIVE SQL EXECUTION PLANS 有权
推荐替代性SQL执行计划的技术

TECHNIQUES FOR RECOMMENDING ALTERNATIVE SQL EXECUTION PLANS
摘要:
Techniques for automatically recommending alternative execution plans for a SQL statement. In one set of embodiments, information pertaining to one or more execution plans for a SQL statement can be retrieved from a set of plan sources. The one or more execution plans can include the current execution plan for the statement and one or more historical execution plans. Based on the retrieved information, the performance of the one or more execution plans can be compared to each other. Based on the comparison, a recommendation can be provided to a user indicating that a particular execution plan (e.g., a historical execution plan) should be used in place of the current execution plan to execute the SQL statement.
公开/授权文献
信息查询
0/0