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