Missing index analysis and index useage statistics
Number of patents in Portfolio can not be more than 2000
United States of America Patent
Stats
-
Aug 3, 2010
Grant Date -
Jun 7, 2007
app pub date -
Dec 2, 2005
filing date -
Dec 2, 2005
priority date (Note) -
In Force
status (Latency Note)
Importance
Abstract
A method of accumulating and aggregating statistics concerning the use of database table indexes includes using a plurality of counters to register index use. The plurality of counters allow multiple instances of index usage to be recorded simultaneously. A missing index may be detected using an optimal index in a query plan. The optimal index is compared against the available indexes to determine if an index is missing. Statistics may be gathered against the used and missing indexes.
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