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
  [...]

Categories: Oracle RSS Feed
PermalinkPermalink