MySQL Forums
Forum List  »  Performance

Re: distinct clause issue for 600000 records
Posted by: Ra Nala
Date: November 12, 2015 12:49AM

I am expecting solution for this. your inputs are valid but how can i fix the issue.

is this issue can be avoid without distinct clause ? is yes please suggest me.

As per my DBA inputs, distinct will cause to CPU usage issues if we have millions of records.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: distinct clause issue for 600000 records
913
November 12, 2015 12:49AM
1053
November 12, 2015 03:20AM
1064
November 13, 2015 12:37AM
1049
November 13, 2015 05:56AM
1119
November 13, 2015 07:15AM
1033
November 13, 2015 11:35AM
1039
November 16, 2015 04:12AM


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.