Re: [PERFORM] seqscan for 100 out of 3M rows, index present

[Willy-Bas Loos]

On Wed, Jun 26, 2013 at 10:31 PM, Jeff Janes <jeff.ja...@gmail.com> wrote:

>
> Why is it retrieving 3.1 million, when it only needs 17?
>
>
> that's because of the sequential scan, it reads all the data.

cheers,

willy-bas
-- 
"Quality comes from focus and clarity of purpose" -- Mark Shuttleworth