Cyril,

>>>>>>>>>>>>
Select b.cfk1, b.cfk2, a.ctype;
FROM vcf!many b ;
INNER Join vcf!one a ON b.cfk1 = a.cid;
WHERE b.namount1 <> 0.00;
OR (b.namount2 <> 0.00);
OR (a.ctype In ("F","8") AND b.namount3 <> 0.00);
GROUP By b.cfk1, b.cfk2


Question for a answer:
a) RECCOUNT(vcf!many) ?

B) RECCOUNT(vcf!one) ?

C) indices ON vcf!many ?

D) indices ON vcf!many ?

E) RECCOUNT(result of select command) ?

F) Time for exec the select.

Fabio