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:
Nov. 20, 2001
Filed:
Feb. 24, 1999
Applicant:
Inventors:
Todd Guay, Nashua, NH (US);
Gregory Smith, Merrimack, NH (US);
Gaylen Royal, Bedford, NH (US);
Cheryl Mrozienski, Strafford, NH (US);
Assignee:
Oracle Corporation, Redwood Shores, CA (US);
Attorney:
Primary Examiner:
Assistant Examiner:
Int. Cl.
CPC ...
G60F 1/730 ;
U.S. Cl.
CPC ...
G60F 1/730 ;
Abstract
An approach for automatically determining database tables that are best suited for index tuning involves analyzing query performance data that specifies an average amount of time required to execute a plurality of queries on the database tables. One or more particular queries are selected from the plurality of queries based upon the query performance data. Data tables required to process the one or more particular queries are selected for index tuning.