Re: Comparitive UPDATE speed

On Fri, Oct 04, 2002 at 11:13:09AM -0700, Josh Berkus wrote:
> 
> Andrew,
> 
> > Have you run this with EXPLAIN ANALYSE?  It will actually perform the
> > necessary steps, so it will reveal if the planner is getting
> > something wrong.
> 
> Here it is:

Oops, sorry.  What if you force the index use here?  Just because the
planner thinks that's more expensive doesn't mean that it is.

A

-- 
----
Andrew Sullivan                         204-4141 Yonge Street
Liberty RMS                           Toronto, Ontario Canada
<andrew@libertyrms.info>                              M2P 2A8
                                         +1 416 646 3304 x110