International Business Machines Corporation

Dale M Stahl

Paul Reuben Day

Roger Alan Mittelstadt

Randy Lynn Egan

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.

Growing community of inventors

Rochester, MN, United States of America

Dale M Stahl