> 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 capiwhat it could do if it was implemented is full index scan on
movimentazioni