CREATE BITMAP INDEX

最新推荐文章于 2023-09-14 20:39:06 发布

转载最新推荐文章于 2023-09-14 20:39:06 发布 · 578 阅读

文章标签：

本文详细介绍了位图索引的概念及使用场景。位图索引为每个唯一键创建位图，而非单独索引每一行。位图存储与键值相关的行ID，适用于并发交易水平较低的应用，例如数据仓库。此外，还解释了Oracle如何处理包含空键值的行。

Specify BITMAP to indicate that index is to be created with a bitmap for each distinct
key, rather than indexing each row separately. Bitmap indexes store the rowids
associated with a key value as a bitmap. Each bit in the bitmap corresponds to a
possible rowid. If the bit is set, then it means that the row with the corresponding
rowid contains the key value. The internal representation of bitmaps is best suited for
applications with low levels of concurrent transactions, such as data warehousing.

————————————————————————————————————————————————————————————————————————————————
Note: Oracle does not index table rows in which all key columns
are null except in the case of bitmap indexes. Therefore, if you want
an index on all rows of a table, then you must either specify NOT
NULL constraints for the index key columns or create a bitmap
index.
————————————————————————————————————————————————————————————————————————————————

[@more@]

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/10599713/viewspace-1001827/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/10599713/viewspace-1001827/