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:
Sep. 18, 2007
Filed:
Nov. 01, 2000
Todd P. Guay, Nashua, NH (US);
Gregory S. Smith, Merrimack, NH (US);
Ari W. Mozes, San Carlos, CA (US);
Gaylen D. Royal, Bedford, NH (US);
Todd P. Guay, Nashua, NH (US);
Gregory S. Smith, Merrimack, NH (US);
Ari W. Mozes, San Carlos, CA (US);
Gaylen D. Royal, Bedford, NH (US);
Oracle International Corporation, Redwood Shores, CA (US);
Abstract
A method evaluates a plurality of candidate index sets for a workload of database statements in a database system by first generating baseline statistics for each statement in the workload. An index superset is formed by combining an existing or current index set and a proposed index set. A candidate index set is derived from the index superset, the candidate index being one of the plurality of candidate index sets. Statistics for a statement are generated by first creating an execution plan which represents an efficient series of steps for executing the statement given the candidate index set. The execution plan is evaluated, and statistics based on the evaluation of the execution plan are generated and recorded. The cost of the execution plan is then determined and statistics are generated. Statistics for each candidate index set are rolled up and presented to a user or an index tuning mechanism.