发明名称 |
Techniques for recommending alternative SQL execution plans |
摘要 |
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. |
申请公布号 |
US8688689(B2) |
申请公布日期 |
2014.04.01 |
申请号 |
US20100827943 |
申请日期 |
2010.06.30 |
申请人 |
YU HAILING;BELKNAP PETER;DAGEVILLE BENOIT;DIAS KARL;YAGOUB KHALED;ORACLE INTERNATIONAL CORPORATION |
发明人 |
YU HAILING;BELKNAP PETER;DAGEVILLE BENOIT;DIAS KARL;YAGOUB KHALED |
分类号 |
G06F7/00;G06F17/30 |
主分类号 |
G06F7/00 |
代理机构 |
|
代理人 |
|
主权项 |
|
地址 |
|