On Tue, 2006-08-01 at 17:39 +0530, ViSolve DB Team wrote: > Hello Prashant, > > If you do need the duplicate rows in the final result, use UNION ALL with > your query. Otherwise you can opt for UNION as UNION is faster than UNION > ALL.
I have never heard of any evidence of this; in fact, it makes more sense that the reverse would be true, as MySQL would not have to do an implicit DISTINCT on the outermost resultset. Prashant: Please post an EXPLAIN of your original posted SQL query. Use the /G flag from the command line client to make it easier to read the results. Thanks! -jay -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
