>I'm not sure, I understand you. UNION uses all fields to compare records to eliminate duplicates. UNION ALL doesn't compare them at all. It's just joins separate queries results into one record set (cursor).

If it is bound on all fields, then, I don't see the need for it. I would have assumes it would have gone by the first field, as in general, it's the primary key, and that would have done it.