Horton

Re: order of nested loop

Tom Lane <tgl@sss.pgh.pa.us>

View thread View on postgr.es
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Jean-Luc Lachance <jllachan@nsd.ca>
Cc: Joseph Shraibman <joseph@xtenit.com>, pgsql-general@postgresql.org
Date: 2003-06-17T15:40:58Z
Lists: pgsql-general 
Jean-Luc Lachance <jllachan@nsd.ca> writes:
> I am currious.  Why perform a sort first?  Would it not be more
> efficient to create an in memory index on the fly?

Why would you think that?  Creating an index involves a sort ...
there's no free lunch there that I can see.

			regards, tom lane