Re: Large(ish) update using inner join crashes server
ok... I know I'm talking to myself here - but I've sorted the problem and thought I'd post my findings - I simply created a better set of custom indexes between the userID and the email and it's taken the query sub-second again. Aplogies for not thinking of this before I posted.
Subject
Written By
Posted
Re: Large(ish) update using inner join crashes server
April 04, 2006 08:08AM
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.