发明名称 |
Missing index analysis and index useage statistics |
摘要 |
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.
|
申请公布号 |
US2007130107(A1) |
申请公布日期 |
2007.06.07 |
申请号 |
US20050292679 |
申请日期 |
2005.12.02 |
申请人 |
MICROSOFT CORPORATION |
发明人 |
WAAS FLORIAN;THOMAS JUEIGEN;HANSON ERIC N.;GALINDO-LEGARIA CESAR A. |
分类号 |
G06F17/30 |
主分类号 |
G06F17/30 |
代理机构 |
|
代理人 |
|
主权项 |
|
地址 |
|