Mark Kirkwood
> > The 'desc' seems to be the guy triggering the sort, e.g:
> 
> Oh; really an accident that I didn't notice myself, I was actually
going
> to
> remove all instances of "desc" in my simplification, but seems like I
> forgot.

If desc is the problem you can push the query into a subquery without
sorting and sort the result.  This is called an inline view.  Sometimes
you can pull a couple of tricks to force the view to materialize before
it is sorted.

aka 
select q.*
from
(
   some_complex_query   
) q order by ...;

Merlin

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

Reply via email to