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
692
November 12, 2015 12:49AM


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.