Invention Grant
- Patent Title: Techniques for recommending parallel execution of SQL statements
- Patent Title (中): 推荐并行执行SQL语句的技术
-
Application No.: US12827926Application Date: 2010-06-30
-
Publication No.: US09256642B2Publication Date: 2016-02-09
- Inventor: Hailing Yu , Peter Belknap , Thierry Cruanes , Benoit Dageville , Karl Dias , Khaled Yagoub
- Applicant: Hailing Yu , Peter Belknap , Thierry Cruanes , 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 for automatically recommending parallel execution of a SQL statement. In one set of embodiments, a first determination can be made regarding whether a SQL statement can be executed in parallel. Further, a second determination can be made regarding whether executing the SQL statement in parallel is faster than executing the statement in serial by a predetermined factor. If the first determination and second determination are positive (i.e., the statement can be executed in parallel and parallel execution is faster by the predetermined factor), a recommendation can be provided indicating that the SQL statement should be executed in parallel. In some embodiments, the recommendation can include a report specifying the degree of performance improvement gained from parallel execution, additional system resources consumed by parallel execution, and other statistics pertaining to the recommended parallel execution plan.
Public/Granted literature
- US20120005188A1 TECHNIQUES FOR RECOMMENDING PARALLEL EXECUTION OF SQL STATEMENTS Public/Granted day:2012-01-05
Information query