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:
Mar. 20, 2012
Filed:
Apr. 06, 2009
Paul R. Day, Rochester, MN (US);
Randy L. Egan, Rochester, MN (US);
Roger A. Mittelstadt, Byron, MN (US);
Dale M. Stahl, Rochester, MN (US);
Paul R. Day, Rochester, MN (US);
Randy L. Egan, Rochester, MN (US);
Roger A. Mittelstadt, Byron, MN (US);
Dale M. Stahl, Rochester, MN (US);
International Business Machines Corporation, Armonk, NY (US);
Abstract
A method, apparatus, and program product is provided to, in response to receiving a first database query for which usage of shared weight indices is prohibited, determine whether a shared weight index associated with a column of a database table referenced by the first database query can be utilized as a non-shared weight index to optimize the database query. The method, apparatus, and program product determine whether the column includes at least one changed weight value and determines whether the database query references at least one changed weight value in the column. The shared weight index is utilized to optimize the first database query in response to determining that the shared weight index can be utilized as a non-shared weight index to optimize the first database query.