Skip to Main Content

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!

Use bitmap indexes to enforce PK ?

3702Feb 19 2004 — edited Feb 19 2004
On a huge table (many GB), I need to change the primary key needs to be changed. This task will be huge, use a lot of temp, io etc.

I know I can use non-unique indexes to enforce uniquness, but does this also apply to bitmap indexes ?

Most (if not all) columns in the PK are fine candidates for bitmap indexes (have already tried it !)

BR,
Kim
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 18 2004
Added on Feb 19 2004
12 comments
260 views