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