For this reason, bitmap indexes are not appropriate for many OLTP applications.
因为这个原因,位图索引不适合于OLTP应用。
Mark all index fragments of all bitmap indexes defined on the table UNUSABLE and rebuild them once the operation is complete.
那么得先找出这个表有哪些索引,哪些索引是位图索引,怎么查呢?
BITMAP Indexes: It is used when the number of distinct values is very less also mostly used on tables that are very less updated or not updated at all.
位图索引:它适用于不同值的数量是非常少的也大多使用的表,很少更新或不更新所有。
Oracle Learning Resources, including the ROWID of the concept, the concept of indexing, unique indexes, composite indexes, bitmap indexes and function-based indexes.
Oracle学习参考,包括ROWID的概念、索引的概念、唯一索引、组合索引、位图索引和 基于函数的索引等。
Indexes that can be compressed are bitmap, btree and index organized tables.
可以压缩的索引有bitmap、btree和索引组织的表。
Building bitmap join indexes of dimension tables and fact tables directly may bring a large number of useless index items that affect query efficiency.
直接建立维度表与事实表的位图连接索引会产生大量无用的索引项,影响查询效率。
Building bitmap join indexes of dimension tables and fact tables directly may bring a large number of useless index items that affect query efficiency.
直接建立维度表与事实表的位图连接索引会产生大量无用的索引项,影响查询效率。
应用推荐