Re: [GENERAL] Indexes and querys

2003-10-22 Thread Peter Eisentraut
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

[GENERAL] Indexes and querys

2003-10-22 Thread Josué Maldonado
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.