So you've created a view to UNION the tables together. It doesn't matter if you union them in a query or in a view, the DISTINCT operation is still going to be performed because of the UNION. In your OP, you said you wanted all the rows, so a UNION ALL is the correct approach. It'll also be faster because it doesn't have to do the DISTINCT.