Steve..

I cite page 247 of Inside SQL Server 7. I did'nt want you to think I pulled this out of thin air...

With that in mind, the only tables that would not need a clustered index would be ones that would not participate in queries - I suppose. At some level, every table participates in a query - to one degree or another...

The advice is that if your table only has 1 index, it should be clustered.

I am sure you will find something that disputes this. Just know that I have at least, some authority on my side of the argument.

A lot of times Steve, you go onto to disagree, but don't cite authority for your opinion. If it is your opinon, fine, but state that.




>>> Every table in SQL Server should have a clustered index
>
>Er, no <s>.
>
>I specifically don't want to go there. Just know that I know this to be an incorrect general heuristic.
>
>**--** Steve