Listing 5 shows a sample of the unused indexes section.
清单5显示了未使用索引部分的示例。
For this scenario, you are mainly interested in the unused indexes section.
对于这个场景,您主要对未使用索引部分感兴趣。
Index recommendations: indexes to create, indexes to keep, then unused indexes.
索引建议:要创建的索引,要保留的索引,然后是未使用的索引。
For this scenario, you are primarily interested in the section that lists the unused indexes.
对于这个场景,您主要对列出未使用索引的部分感兴趣。
The output file created by the Design Advisor consists of three sections: recommended additional indexes, recommended existing indexes, and unused indexes.
Design Advisor创建的输出文件包含3个部分:建议的额外索引、建议的现有索引和未使用索引。
This article demonstrates different approaches to identify unused and seldom used indexes defined within a database.
本文展示了几种方法,用于识别在数据库中定义的未使用和很少使用的索引。
Unused and seldom used indexes cause UID operations (UPDATE, INSERT, and DELETE) and database maintenance activities (such as RUNSTATS and REORG) to run unnecessarily long.
未使用和很少使用的索引可能导致UID操作(update、INSERT和DELETE)和数据库维护活动(比如runstats和REORG)的运行时间更长。
Doug Lea's allocator has a basic structure much like our version, but it incorporates indexes to make searching faster and has the ability to combine multiple unused chunks into one large chunk.
DougLea的分配程序有着与我们的版本非常类似的基本结构,但是它加入了索引,这使得搜索速度更快,并且可以将多个没有被使用的块组合为一个大的块。
The exception is that any internal indexes for LOB columns that are marked unused are not removed.
例外情况是被标识为不可用的LOB列的内部索引不会被移除。
The exception is that any internal indexes for LOB columns that are marked unused are not removed.
例外情况是被标识为不可用的LOB列的内部索引不会被移除。
应用推荐