Re: estimated rows vs. actual rows

On Sun, 13 Feb 2005 13:41:09 -0800, Josh Berkus  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