Re: Slow performance
Thank you for the response. But, I need all the records from mantis_bug_table and the service agent name if it has any from sadb. So, I have to use left join only. If I use INNER JOIN, I will not get records from mantis_bug_table if it doesn't have corresponding service agent in sadb.
But, my question is, why it has to take this much time for a simple join. This mantis_bug_table is located in national_jim db. So, I am trying to join national_jim to national_sam db. We already have many joins to this national_sam db from other dbs and no issues with those queries. Only issue is with this db. Not sure what other factors depend on performance on joins to different tables of different db's.
Subject
Views
Written By
Posted
2536
July 24, 2012 02:03PM
982
July 25, 2012 02:49AM
Re: Slow performance
1056
July 26, 2012 03:43AM
1044
July 26, 2012 04:05AM
702
July 27, 2012 09:34AM
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.