Automatic database statistics maintenance and plan regeneration
Number of patents in Portfolio can not be more than 2000
United States of America Patent
Stats
-
Apr 2, 2002
Grant Date -
N/A
app pub date -
Dec 16, 1998
filing date -
Dec 16, 1998
priority date (Note) -
In Force
status (Latency Note)
Importance
Abstract
A system for automatically maintaining database statistics comprises a query optimizer which automatically generates statistics derived from data in a database and selects an executable procedure from a plurality of procedures that operate on data in the database using the automatically generated statistics. The query optimizer maintains counters of changes made to the data and automatically updates statistics derived from the data when the counters exceed a threshold. A statistic schema version is maintained for each statistic and incremented when the underlying data is updated. If the statistic schema version changes from that value with which the execution plan was generated, the execution plan is discarded and a new execution plan developed.
First Claim
Family
International Classification(s)
Cited Art Landscape
Patent Citation Ranking
Advertisement
Advertisement
Advertisement
Recipient Email Address
Recipient Email Address
Comment
Recipient Email Address
Add to Portfolio(s)
To add this patent to one, or more, of your portfolios, simply click the add button.
This Patent is in these Portfolios:
Add to additional portfolios:
Last Refreshed On:
Changes done successfully