Short Sorts

Link: http://jonathanlewis.wordpress.com/2009/12/28/short-sorts/

I posted a little holiday quiz – timed to appear just before midnight (GMT) on 24th December – that asked about the number of rows sorted and the memory used for queries like:

select sortcode
from
(
? select sortcode
? from t1
order by
? [...]