Originally posted by slimdave
... and when the table is moved.
It used to be the case that making any column nullable or non-nullable would make all the bitmap indexes unusable, so there's another one.
Moving has been mentioned before.
Bottom line, it looks like we are rebuilding our indexes all the time.
This sounds familiar... index rebuilding... Windows rebooting... 
Raminder: when you will get your database upgraded, you will be able to put a trigger on DDL - enabling you to get 100% rebuild history 
Tomaž
"A common mistake that people make when trying to design something completely
foolproof is to underestimate the ingenuity of complete fools" - Douglas Adams
Reply With Quote