Monday 18 January 2010

bitmap indexesneed frequent rebuilds

Do they or do they not deteriorate over time (i.e. after lots of inserts/updates) and need rebuilding?

Does this answer the question?
http://technology.amis.nl/blog/1420/myths-on-bitmap-indexes

The Jonathon Lewis' response #18 seems to suggest that it is only true after many 'updates' but not many inserts