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:
Apr. 01, 2014
Filed:
Jun. 30, 2010
Hailing Yu, San Jose, CA (US);
Peter Belknap, Redwood City, CA (US);
Benoit Dageville, Truckee, CA (US);
Karl Dias, Foster City, CA (US);
Khaled Yagoub, Fremont, CA (US);
Hailing Yu, San Jose, CA (US);
Peter Belknap, Redwood City, CA (US);
Benoit Dageville, Truckee, CA (US);
Karl Dias, Foster City, CA (US);
Khaled Yagoub, Fremont, CA (US);
Oracle International Corporation, Redwood Shores, CA (US);
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.