On Thu, Mar 06, 2003 at 10:38:09PM -0700, Robert Wille wrote:
> I am trying to execute an update that has a subselect, and it takes an extraordinarily long time.
> By performing the subselect in my application, and issuing the update multiple times, it appears that I can do the entire update about 400 times faster.
Try using EXISTS rather than IN. It tends to work better.
Hope this helps,
--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> Support bacteria! They're the only culture some people have.