Information générale
Forum:
Microsoft SQL Server
Wishing all a Happy Lunar New Year and all the best for the
years to come.
Michael, would you care to explain to me what is and the diff.
between NC(non-cluster) indexes and cluster indexes. Thanks.
>Since there's no activity here maybe I can generate some...
>This is a favorite of mine. First, without trying it, which query would you expect to generate more IO:
>SELECT MIN(column1), MAX(column1) FROM table
>SELECT MIN(column1), (SELECT MAX(column1) FROM table) FROM table
>IMPORTANT: It only works on 6.5 and there must be an NC index on column1!!!
>After you've guessed, run both queries. Don't forget to SET STATS IO ON to get the IO counts.
>Have fun
>-Mike
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