Patent ID: 7007006
Filing Date: 2006-02-28
Classification: G06F,Y10S

Abstract:
1. A computer implemented method of determining candidate indexes and candidate materialized views for a database system in a computer comprising the steps of: a) receiving workload information, system information, and database information, as input, b) generating a set of materialized view candidates, and index candidates; c) consolidating the materialized view candidates and index candidates into a consolidated set of materialized views and indices, d) weighting the materialized view candidates and index candidates by a measure of performance benefit of the materialized view candidates or index candidates divided by disk space required by the said materialized view candidates or index candidates; and e) selecting a set of candidate indexes and candidate materialized views by starting with an empty list of candidate materialized views and indexes, and successively adding a next index or materialized view with the highest weight to the list to thereby generate an ordered list of candidate materialized views and candidate indexes.