Re: Query not using index despite high statistics - Mailing list pgsql-general

4 maj 2007 kl. 18:09 skrev Tom Lane:

> Henrik Zagerholm <henke@mac.se> writes:
>> I have a SELECT  query that uses Seq scans instead of index scan
>> despite that the index scan is faster.
>
> Try 8.2, it's a bit smarter about the costs of repeated indexscans
> on the inside of a nestloop.
>
Ahh sorry for forgetting the db version.
We are actually using 8.2.3.

Cheers, henrik