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(at)libertyrms(dot)info> M2P 2A8
+1 416 646 3304 x110