Re: distinct clause issue for 600000 records
Hi,
I agree that IN-subqueries are better than DISTINCT. Avoiding duplicates in the first place will perform better than removing them afterwards. With MySQL 5.6 it should perform better, IN-subqueries should have better performance than before.
I still do not understand what cardinality length is.
Øystein Grøvlen,
Senior Principal Software Engineer,
MySQL Group, Oracle,
Trondheim, Norway
Subject
Views
Written By
Posted
2111
November 10, 2015 08:57AM
1228
November 11, 2015 12:33PM
1110
November 12, 2015 12:49AM
1205
November 12, 2015 03:20AM
1118
November 12, 2015 07:24PM
1326
November 12, 2015 07:08AM
1320
November 12, 2015 07:18AM
1384
November 12, 2015 07:43AM
1250
November 13, 2015 12:37AM
1364
November 13, 2015 12:45AM
1398
November 13, 2015 02:42AM
1397
November 13, 2015 05:56AM
1188
November 13, 2015 06:38AM
1274
November 13, 2015 07:15AM
1257
November 13, 2015 08:11AM
1177
November 13, 2015 11:35AM
1259
November 16, 2015 03:04AM
1172
November 16, 2015 04:12AM
Re: distinct clause issue for 600000 records
1113
November 16, 2015 05:54AM