SELECT MyField FROM Parent; INNER JOIN Child ON Parent.Numero=Child.ParentNumero; INTO CURSOR TempAssuming Parent.Numero is having a type of Integer and Child.ParentNumero is having a type of Numeric(6), would that be optimized? So, in order to be fully optimized, should the types be all the same?