The patent badge is an abbreviated version of the USPTO patent document. The patent badge does contain a link to the full patent document.
The patent badge is an abbreviated version of the USPTO patent document. The patent badge covers the following: Patent number, Date patent was issued, Date patent was filed, Title of the patent, Applicant, Inventor, Assignee, Attorney firm, Primary examiner, Assistant examiner, CPCs, and Abstract. The patent badge does contain a link to the full patent document (in Adobe Acrobat format, aka pdf). To download or print any patent click here.
Patent No.:
Date of Patent:
Feb. 09, 2016
Filed:
Jun. 30, 2010
Hailing Yu, San Jose, CA (US);
Peter Belknap, Redwood City, CA (US);
Thierry Cruanes, Foster City, CA (US);
Benoit Dageville, Truckee, CA (US);
Karl Dias, Foster City, CA (US);
Khaled Yagoub, Newark, CA (US);
Hailing Yu, San Jose, CA (US);
Peter Belknap, Redwood City, CA (US);
Thierry Cruanes, Foster City, CA (US);
Benoit Dageville, Truckee, CA (US);
Karl Dias, Foster City, CA (US);
Khaled Yagoub, Newark, CA (US);
Oracle International Corporation, Redwood Shores, CA (US);
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.