首页>
外国专利>
Missing index analysis and index useage statistics
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.
展开▼