Re: FW: Simple join optimized badly? - Mailing list pgsql-performance

From Mark Kirkwood
Subject Re: FW: Simple join optimized badly?
Date
Msg-id 452E11FB.7070704@paradise.net.nz
Whole thread Raw
In response to FW: Simple join optimized badly?  ("H.J. Sanders" <hjs@rmax.nl>)
Responses Re: FW: Simple join optimized badly?  ("Jim C. Nasby" <jim@nasby.net>)
List pgsql-performance
H.J. Sanders wrote:

>  why not just like in some other (commercial) databases:
>
>  a statement to say: use index ............
>
>  I know this is against all though but if even the big ones can not resist
>  the pressure of their users, why not?
>

Yeah - some could not (e.g. Oracle), but some did (e.g. DB2), and it
seemed (to me anyway) significant DB2's optimizer worked much better
than Oracle's last time I used both of them (Oracle 8/9 and DB2 7/8).

cheers

Mark

pgsql-performance by date:

Previous
From: "H.J. Sanders"
Date:
Subject: FW: Simple join optimized badly?
Next
From: "Jim C. Nasby"
Date:
Subject: Re: FW: Simple join optimized badly?