Re: distinct clause issue for 600000 records
Hi,
I suspect what you want is
SELECT ee.id FROM extn ee
WHERE ee.id IN (select id from srl) AND ee.id=2662;
As long as you have indexes on your id columns, I think performance should not be an issue.
Øystein Grøvlen,
Senior Principal Software Engineer,
MySQL Group, Oracle,
Trondheim, Norway
Subject
Views
Written By
Posted
2075
November 10, 2015 08:57AM
1197
November 11, 2015 12:33PM
1077
November 12, 2015 12:49AM
1176
November 12, 2015 03:20AM
1090
November 12, 2015 07:24PM
Re: distinct clause issue for 600000 records
1301
November 12, 2015 07:08AM
1295
November 12, 2015 07:18AM
1338
November 12, 2015 07:43AM
1214
November 13, 2015 12:37AM
1329
November 13, 2015 12:45AM
1366
November 13, 2015 02:42AM
1363
November 13, 2015 05:56AM
1161
November 13, 2015 06:38AM
1256
November 13, 2015 07:15AM
1227
November 13, 2015 08:11AM
1165
November 13, 2015 11:35AM
1236
November 16, 2015 03:04AM
1159
November 16, 2015 04:12AM
1102
November 16, 2015 05:54AM