...决策支持系统;位图索引;水平分区;性能优化 [gap=771]Key words: data warehouse; decision support system; bitmap indexes; horizontal partitioning; optimization ...
基于36个网页-相关网页
Bitmap Join Indexes 位图连接索引
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.
位图索引:它适用于不同值的数量是非常少的也大多使用的表,很少更新或不更新所有。
应用推荐