|
-
Hi,
when Bitamp-indexes then :
* They are one of the fastest access-path for big tables
* sometimes u have to use the INDEX_COBINE-Hint
* you will have slower Insert-Rate, more CPU is needed
* The BM-index do not like heavy updates/ inserts
* you will ahve tor reorg them
* init.ora bm-params to set
I would decide not to mix a prtitioned table wit bm-indexes (common statement )
I would even divide the table in more partitions. 60 instead of 6 if its possible.
But when you want to query the table flexible than i understand that you would like to have more single-col-bm-indexes. so mixing te two techniques probalby could work.
So there is no clear no or yes even mor a fuzzy no/Yes
Orca
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|