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. ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org