On Sun, 13 Feb 2005 13:41:09 -0800, Josh Berkus <josh@agliodbs.com> wrote:
> Jaime,
>
> > Why is this query using a seq scan rather than a index scan?
>
> Because it thinks a seq scan will be faster.
>
I will suggest him to probe with seq scans disabled.
But, IMHO, if the table has 143902 and it thinks will retrieve 2610
(almost 1.81% of the total). it won't be faster with an index?
i know, i will suggest him to probe to be sure. just an opinion.
regards,
Jaime Casanova