MySQL Forums
Forum List  »  Performance

Re: distinct clause issue for 600000 records
Posted by: Øystein Grøvlen
Date: November 16, 2015 05:54AM


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

Options: ReplyQuote

Written By
Re: distinct clause issue for 600000 records
November 16, 2015 05:54AM

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.