General information
Forum:
Microsoft SQL Server
Hi Michael:
I'm guessing that SELECT MIN(column1), MAX(column1) FROM table does based upon the NC criteria that was specified.
What's the answer<s>.
CT
>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
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only