> real 107m48.354s
> user 0m1.140s
> sys 0m0.040s
>
Please give us output of:
explain SELECT movimentazioni.azienda
> FROM movimentazioni,capi
> where ((capi.matricola = movimentazioni.matricola )
> and (capi.specie = movimentazioni.specie ) );
>
Andreas
PS: what it should do is seq scan on movimentazioni and index path
on capi
what it could do if it was implemented is full index scan on
movimentazioni