Re: distinct clause issue for 600000 records
Posted by:
Ra Nala
Date: November 13, 2015 11:35AM
Øystein Grøvlen Sir, hope will expect answer from your end.
Distinct clause issue having only in MySQL database or some other database as well?. I have worked on Oracle, Db2, MS Sql SERVER i have't faced issue in these databases. Strange issue in MySQL databases, wasn't expected.
I can write subselect query instead of left joins , will try to modify my queries. Is Cardinality length causes issues for performance?.
Subject
Views
Written By
Posted
2028
November 10, 2015 08:57AM
1124
November 11, 2015 12:33PM
1008
November 12, 2015 12:49AM
1122
November 12, 2015 03:20AM
1024
November 12, 2015 07:24PM
1231
November 12, 2015 07:08AM
1201
November 12, 2015 07:18AM
1247
November 12, 2015 07:43AM
1140
November 13, 2015 12:37AM
1240
November 13, 2015 12:45AM
1273
November 13, 2015 02:42AM
1282
November 13, 2015 05:56AM
1107
November 13, 2015 06:38AM
1190
November 13, 2015 07:15AM
1159
November 13, 2015 08:11AM
Re: distinct clause issue for 600000 records
1121
November 13, 2015 11:35AM
1187
November 16, 2015 03:04AM
1119
November 16, 2015 04:12AM
1063
November 16, 2015 05:54AM