Method and system for histogram determination in a database

摘要: A method and system for determining when to collect, save, and/or utilize histograms is disclosed. mechanism automatically deciding collect upon request from the user provided. The histogram collection decision based on columns interested in, role these play in queries as submitted system, underlying distribution columns, e.g., seen a random sample. specifies which are of interest, database configured column usage information that describes how each being used workload. This could be stored memory periodically flushed disk. Given set potential those viewed combination with determine should have histograms.