Re: Using NOT IN
I guess it was a timing issue where NOT IN would have finished if I waited long enough because using LEFT JOIN instead seems to work. However, it works in 89 seconds! I'm the only that will be using this procedure but I have to run it around 800 times a week.
I have 125,000 rows in Rankings (This will grow)
I have 120 rows in Rankings when the conditional statements are accounted for
I have 245 rows in Teams
Is there anything I can do to make this run faster?
Subject
Written By
Posted
Re: Using NOT IN
January 02, 2011 09:11PM
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.