how come when I run dbcc dbreindex on some indexes it doesn't change the scandensity to 100%? I'm not using fill factor. Very often (though not exclusively)this happens on columns which are indexed twice - once as a primary key and then again. I know you shouldn't do this but the dbreindex issue puzzles me.