Re: Basic question about indexes/explain

Am Samstag, 26. Oktober 2002 12:27 schrieb Terry Yapt:
> Hi all,
>
snip
> I have a basic doubt about indexes...  in the next example:
> But if we have an index with the two colums I am using in the WHERE clause,
> why is the planner using seq scan ?  (Or perhaps it is because too few rows
> in the table ?)....

First of all, you did not analyze your table (at least you did not mention you did). And an index is never a win for
sucha small table. I think the planner is fine here to select a seq scan, because your whole table is only 1 database
page,so it would be no win to check the index here. 

Everything is explained in the manual, check http://developer.postgresql.org/docs/postgres/indexes.html

regards,
    mario weilguni