Le 16/03/2010 16:52, Tom Lane a écrit :
Sometime in the future they might generate the same plan. Right now the
planner's ability to optimize sub-SELECTs is pretty limited, and so you
typically get a nestloop-like plan even if some other join style would
be faster.
OK, thanks for the clarification.
Should joins always be considered better than subselects then ?
I like the readability of subselects and I think I use them more often
than joins when I have the choice, so maybe I should check and change
all my queries ?
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
