Invention Grant
US08688689B2 Techniques for recommending alternative SQL execution plans 有权
推荐替代SQL执行计划的技术

Techniques for recommending alternative SQL execution plans
Abstract:
Techniques are provided for automatically recommending alternative execution plans for a SQL statement. 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.
Public/Granted literature
Information query
Patent Agency Ranking
0/0