SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Changing from bitmap indexes to Btree

807285Jan 25 2012 — edited Jan 25 2012

Hi all,

oracle 11.2.0.1.0

I am working on a requirement to change bitmap indexes to b tree indexes. The bitmap indexes were created about 3-5 years ago. They were periodically analyzed. Since the data , unique data to be precise is increasing , we have resorted to change to btree indexes.

Can any one tell how should i start and the parameters i need to keep in mind while jusdging the enhanced performance. Also, I have read about clustering factor to as near to number of rows possible ... Please provide some direction into this...

Regards
VK

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 22 2012

Added on Jan 25 2012

#11g

12 comments

453 views