On Fri, 2004-07-23 at 15:51, Jaime Casanova wrote:
> Hi all,
>
> just as a question.
>
> There will be some day a feature that let you force
> the planner to use an specific index, like oracle
> does?
>
> Of course the planner is smart enough most times but
> sometimes such an option would be usefull, don't you
> think so?
A planner that always made the right choice would be the most useful
thing. After that, the ability to "push" the planner towards an index
would be pretty nice.
Adding features that make PostgreSQL more error prone (i.e. forcing
particular index usage, etc.) and harder to drive but allow an expert to
get what they want is kind of a dangerous road to tread.
