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 comparison, so Postgres does its best. And I don't constantly want to switch on and off the hashjoin and mergejoin.


Silke Trissl

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Reply via email to