Invention Grant
- Patent Title: Monitoring usage of components in a database index
- Patent Title (中): 监视数据库索引中组件的使用情况
-
Application No.: US12056442Application Date: 2008-03-27
-
Publication No.: US07730045B2Publication Date: 2010-06-01
- Inventor: Eric Lawrence Barsness , John Matthew Santosuosso
- Applicant: Eric Lawrence Barsness , John Matthew Santosuosso
- Applicant Address: US NY Armonk
- Assignee: International Business Machines Corporation
- Current Assignee: International Business Machines Corporation
- Current Assignee Address: US NY Armonk
- Agency: Martin & Associates, LLC
- Agent Derek P. Martin
- Main IPC: G06F12/00
- IPC: G06F12/00 ; G06F17/30

Abstract:
Database indexes include multiple fields that are used to track how the components of the index are used. An index component monitoring mechanism tracks how the components of the index are used, and updates fields in the index accordingly. Such component-level statistics allow a query optimizer to make more intelligent decisions regarding when to build a new index and when to discard an index, and also provide information regarding which queries are using the index, the maintenance cost of the index, and the selectivity of the index when used to process a query.
Public/Granted literature
- US20080177697A1 MONITORING USAGE OF COMPONENTS IN A DATABASE INDEX Public/Granted day:2008-07-24
Information query