On 05/10/10 14:10, Jayadevan M wrote:
When we do a union, the database has to get rid of duplicates and get distinct values. To achieve this, probably it does a sort. Just guesswork....
You are right, it looks like I have inverted the logic of UNION and UNION ALL - I actually needed "UNION ALL" here, thanks!
-- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
