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!