4 maj 2007 kl. 18:09 skrev Tom Lane:
Henrik Zagerholm <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
