|
-
FYI bitmap conversion/AND operations are not exclusively for bitmap indexes, btree indexes are perfect candidates for this type of operations, most of times is for those queries such as
select
from t1
where c1 = :a -> indexed by t1_idx1
and c2 = :b -> indexed by t1_idx2
Oracle will scan both indexes and merge the results using bitmap operations
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
|