>>I never wondered about that situation but I thought I would ask for feedback. Basically, it never caused me any problem but here is the situation.
>>
>>When doing a SQL, such as:
>>
>>
>>SELECT MyField FROM Parent;
>> INNER JOIN Child ON Parent.Numero=Child.ParentNumero;
>> INTO CURSOR Temp
>>
>>
>>Assuming 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?
>
>You can use SYS(3054,11) to display the level of optimization.
Thanks Sergey, that one was part of the problem we had today with the Web Service. Basically, the technique I am now using is doing it ok. Thanks for the help