Invention Grant
- Patent Title: Techniques for recommending alternative SQL execution plans
- Patent Title (中): 推荐替代SQL执行计划的技术
-
Application No.: US12827943Application Date: 2010-06-30
-
Publication No.: US08688689B2Publication Date: 2014-04-01
- Inventor: Hailing Yu , Peter Belknap , Benoit Dageville , Karl Dias , Khaled Yagoub
- Applicant: Hailing Yu , Peter Belknap , Benoit Dageville , Karl Dias , Khaled Yagoub
- Applicant Address: US CA Redwood Shores
- Assignee: Oracle International Corporation
- Current Assignee: Oracle International Corporation
- Current Assignee Address: US CA Redwood Shores
- Agency: Kilpatrick Townsend & Stockton LLP
- Main IPC: G06F7/00
- IPC: G06F7/00 ; G06F17/30

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
- US20120005189A1 TECHNIQUES FOR RECOMMENDING ALTERNATIVE SQL EXECUTION PLANS Public/Granted day:2012-01-05
Information query