Skip to Main Content
Forums

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!

Bitmap join index on accumulator table

432386Jul 14 2008 — edited Jul 15 2008
I have a fact table regarding orders. There are columns for created, completed, and last_modified date. All of these columns reference a generic date dimension table. Is there a way to create bitmap join indexes for all of these columns back to the date dimension table? Oracle complains that the PK of the dimension table is already indexed: ORA-01408: such column list already indexed

Oracle 10.2.0.3 EE.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 12 2008
Added on Jul 14 2008
#general-database-discussions
6 comments
483 views