Hi,

I can see how it would be true for a handful of pages (less than 8) but since the index is created from scratch, I for one cannot see why the pages would be allocated from all over the place.

You mentioned it happens for ALL tables (with more or equal than 3 levels) and always index level 2. Is it so that if there are more levels, it is still just level 2? I suppose some of them have clustered indexes and some are heaps, or?

I am still very puzzled, do you get the same result if you do CREATE INDEX .... WITH DROP_EXISTING?

Which service pack level are you on?

/Elisabeth