Re: distinct clause issue for 600000 records
Hi,
My approach is not applicable to your example since all join conditions are related to your left hand table. A better example is the following (based on your original query):
select *
from prdsl psrl
left join prdgn rn on rn.prdsld=psrl.id
left join be_en bcu on bcu.id=rn.cbed
If every value of rn.cbed is an id in bcu, the above query is equivalent to
select *
from prdsl psrl
left join
(prdgn rn join be_en bcu on bcu.id=rn.cbed)
on rn.prdsld=psrl.id;
Øystein Grøvlen,
Senior Principal Software Engineer,
MySQL Group, Oracle,
Trondheim, Norway
Subject
Views
Written By
Posted
1599
November 10, 2015 08:57AM
861
November 11, 2015 12:33PM
693
November 12, 2015 12:49AM
852
November 12, 2015 03:20AM
790
November 12, 2015 07:24PM
917
November 12, 2015 07:08AM
807
November 12, 2015 07:18AM
781
November 12, 2015 07:43AM
849
November 13, 2015 12:37AM
782
November 13, 2015 12:45AM
817
November 13, 2015 02:42AM
852
November 13, 2015 05:56AM
844
November 13, 2015 06:38AM
872
November 13, 2015 07:15AM
Re: distinct clause issue for 600000 records
906
November 13, 2015 08:11AM
847
November 13, 2015 11:35AM
917
November 16, 2015 03:04AM
835
November 16, 2015 04:12AM
733
November 16, 2015 05:54AM