MySQL Forums
Forum List  »  General

Re: Particular SQL takes more than 5 hours to run in SQL developer
Posted by: Dorothy Timina
Date: May 05, 2016 12:50AM

The query is generated by ODI tool on its own we cannot change the querying technique designed in the tool.

Need a confirmation that will this exists condition will be slow even if we are testing it with 100000 records on the above query?

Is there any DB level settings to be changed to improve this query efficiency.

Thanks,
Gowtham Raja
+91 9787585961

Options: ReplyQuote




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.