Use bitmap indexes to enforce PK ?
3702Feb 19 2004 — edited Feb 19 2004On 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