Automatic database statistics maintenance and plan regeneration

摘要: A system for automatically maintaining database statistics comprises a query optimizer which generates derived from data in and selects an executable procedure plurality of procedures that operate on the using generated statistics. The maintains counters changes made to updates when exceed threshold. statistic schema version is maintained each incremented underlying updated. If value with execution plan was generated, discarded new developed.