Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
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
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement