MySQL Forums
Forum List  »  Performance

distinct clause issue for 600000 records
Posted by: Rami Nalamalpu
Date: November 10, 2015 08:57AM

Hi,

I am facing issue with distinct clause whenever i am trying to retrieve 600000 records using one of the tool(pdi-etl tool),here issue is with CPU usage up to 100% .

As per my DBA input, the root cause for my issue is DISTINCT , i kept distinct clause in my select query because of getting duplicate records even though i have unique data. actually i should not get duplicate data why because i have all records with columns are unique.

Due to this distinct i am reaching CPU usage upto 100% how can i avoid duplicate records in MySQL database.

below is my sample query, when i join with other table then i am getting duplicate records but i have only one record.

select ee.id
from extn ee
left join srl prd on prd.id =ee.id where ee.id=2662

Thank you

Options: ReplyQuote


Subject
Views
Written By
Posted
distinct clause issue for 600000 records
1595
November 10, 2015 08:57AM


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.