Josué Maldonado writes:
> I have a table with an index in a foreing key field (int4), if I do
> select from pedido where prvdfk=3, explain says is using seq scan to
> access it. I noticed all my querys runs in that way, except in the
> querys where the PK field (unique type index) is included in t
Hello list,
I have a table with an index in a foreing key field (int4), if I do
select from pedido where prvdfk=3, explain says is using seq scan to
access it. I noticed all my querys runs in that way, except in the
querys where the PK field (unique type index) is included in the where
clause.