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:
Jul. 12, 2011
Filed:
Jul. 30, 2008
Peter Belknap, Redwood City, CA (US);
Khaled Yagoub, Newark, CA (US);
Karl Dias, Foster City, CA (US);
Benoit Dageville, Foster City, CA (US);
Thierry Cruanes, Foster City, CA (US);
Anupam Singh, San Jose, CA (US);
Peter Belknap, Redwood City, CA (US);
Khaled Yagoub, Newark, CA (US);
Karl Dias, Foster City, CA (US);
Benoit Dageville, Foster City, CA (US);
Thierry Cruanes, Foster City, CA (US);
Anupam Singh, San Jose, CA (US);
Oracle International Corp., Redwood Shores, CA (US);
Abstract
Systems, methods, and other embodiments associated with hybrid optimization strategies in automatic SQL tuning are described. One example method includes receiving a first (e.g., cost-based) execution plan for a user structured query language statement (User SQL) from a first (e.g., cost-based) optimizer. The example method may also include receiving a second (e.g., rules-based) execution plan for the User SQL from a second, different (e.g., rules-based) query optimizer. The method may include identifying a preferred execution plan based on data produced by test executing the execution plans in a reproduced execution environment that reproduces at least a portion of an execution environment in which the user SQL runs. The method may also include controlling a database to execute the User SQL using the preferred execution plan.