MySQL Forums
Forum List  »  Performance

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?.

Options: ReplyQuote

Written By
Re: distinct clause issue for 600000 records
November 13, 2015 11:35AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.