[PERFORM] Tell postgres which index to use?

Hi, is there a way to tell Postgres which index to use when a query is issued in 7.4.2? I have a query for which costwise a Hash-Join and no Index-Usage is the best, but timewise using the index and then do a NestedLoop join is much better (3 - 4 times). I have vacuumed before I started the

Re: [PERFORM] Tell postgres which index to use?

Silke, is there a way to tell Postgres which index to use when a query is issued in 7.4.2? PostgreSQL adjusts usage through global parameters, statistics, and periodic ANALYZE. Please post an EXPLAIN ANALYZE (not just EXPLAIN) for your query and people on this list can help you with your