Oracle Database Discussions

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!

Rebuild or recreate bitmap indexes in Datawarehouse System

424878Jul 7 2004 — edited Jul 7 2004

I have one fact table with 1 million rows and 37 bitmap indexes (with nologging option). When I run the load process, I put the indexes in unusable status and after that I rebuild them.

The process to rebuild indexes takes one and a half hour. It´s a long time!!!

Has everyone had this problem before? Could anybody give me a suggestion to solve this problem?

Thanks

Rosangela Reis

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 4 2004

Added on Jul 7 2004

#general-database-discussions

4 comments

324 views