MySQL Forums
Forum List  »  Performance

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

yes you are correct indexes on id columns, performance should not be an issue.

and i can write sub select Sir, but here i given my sample query as small one but actually query having lot of LEFT joins.

In this case i should not go for "sub select" why because i need to retrieve millions of records may be nearly 600000 to 5000000 records.

I am using ETL tool as Pentaho data integration that is not able to load 5000000 records at the same time. unable to process in temp table due to this reason i missing records.

Options: ReplyQuote

Written By
Re: distinct clause issue for 600000 records
November 12, 2015 07:18AM

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.