Re: distinct clause issue for 600000 records
Hi,
Without seeing the actual query, it is not easy to give any general advice on this. However, the first step should be to consider what LEFT JOINs are strictly necessary. If you use MySQL 5.6, there should be no reason to avoid IN-subqueries. MySQL will be able to convert them into join and remove duplicates automatically if necessary.
Øystein Grøvlen,
Senior Principal Software Engineer,
MySQL Group, Oracle,
Trondheim, Norway
Subject
Views
Written By
Posted
2048
November 10, 2015 08:57AM
1152
November 11, 2015 12:33PM
1035
November 12, 2015 12:49AM
1146
November 12, 2015 03:20AM
1049
November 12, 2015 07:24PM
1263
November 12, 2015 07:08AM
1254
November 12, 2015 07:18AM
Re: distinct clause issue for 600000 records
1301
November 12, 2015 07:43AM
1171
November 13, 2015 12:37AM
1291
November 13, 2015 12:45AM
1323
November 13, 2015 02:42AM
1324
November 13, 2015 05:56AM
1127
November 13, 2015 06:38AM
1222
November 13, 2015 07:15AM
1184
November 13, 2015 08:11AM
1139
November 13, 2015 11:35AM
1214
November 16, 2015 03:04AM
1137
November 16, 2015 04:12AM
1079
November 16, 2015 05:54AM