>Jim..
>
>Nice job on summarizing the issue. Much of what you cited here, I have cited the same authority. Based on what I have read and my experience, clustered indexes are a must-have in any SQL Server Table.

John

Yea, I knew you had cited it. I just thought that the actual words would be more helpful.

I suspect too that some things in this area may have changed from prior versions and that people may be applying old theory in a new base.

I still remember the revelation regarding a TAG on DELETED() vs query performance. While I do not at all doubt the (new) situation, I am a minority of about 1 when I keep insisting that I feel POSITIVE that it used to work differently, and always with positive effect, in FPD 2.6 and prior.

So I feel your pain on this one < s >