Hash index model is to check the index data and create the bitmap index of the index data.
哈希索引亡储模式从要非判续索引数据非否亡反在,树立索引数据的位图索引。
Mark all index fragments of all bitmap indexes defined on the table UNUSABLE and rebuild them once the operation is complete.
那么得先找出这个表有哪些索引,哪些索引是位图索引,怎么查呢?
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.
直接建立维度表与事实表的位图连接索引会产生大量无用的索引项,影响查询效率。
Cannot have global partition with bitmap type index. The partition will be set to default.
不能使用带有位图类型索引的全局分区。该分区将被设置为默认值。
Cannot have global partition with bitmap type index. The partition will be set to default.
不能使用带有位图类型索引的全局分区。该分区将被设置为默认值。
应用推荐