|
-
The order I think is Bitmap,IOT,cluster.
You create a bitmap index on a Normal table.We are using Bitmap indexes a lot i have not seen any decrease in performance while inserting or updating.
If you want to improve performance pls try partitions also.
You can go for range partitions from a-z,numbers,date also.
Normally in many cases i tried to avoid bitmap indexes and tried partitions on those columns you will not belive the performance gain what you get.
So in addition to all these psl consider partitions also .
Radhakrishnan.M
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
|