Re: Sequence Scan vs. Index scan

On Tue, Mar 21, 2006 at 03:08:07PM -0300, Fernando Lujan wrote:
> I'm trying to figure out when Sequence Scan is better than Index Scan. I
> just want to know this because I disabled the sequence scan in
> postgresql and receive a better result. :)

That is a very broad question, and you're introducing somewhat of a false
choice since you're talking about joins (a join can be solved by more methods
than just "sequential scan" or not).

Could you please paste the exact query you're using, with EXPLAIN ANALYZE for
both the case with and without sequential scans?

/* Steinar */
--
Homepage: http://www.sesse.net/