Automatic database statistics creation
A system for automatic statistics creation 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 a database using the automatically generated statistics. A counte...
Saved in:
Main Authors | , |
---|---|
Format | Patent |
Language | English |
Published |
30.10.2007
|
Online Access | Get full text |
Cover
Loading…
Summary: | A system for automatic statistics creation 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 a database using the automatically generated statistics. A counter is maintained of updates made to each statistic that has been automatically generated. If the counter breaches a threshold, the automatically generated statistic is removed from the database. |
---|