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