>Hi Fabio,
>
>>>>What SYS(3054) said about this SELECT?
>>>Joining intermediate result and table employee_queue_schedules (Cartesian product)
>
>>add
>>
>>index ON cTrans_Employees_Queues_fk IN Employee_Queue_Schedules
>>
>I watched vfp creating a temp index often in similar situations where that was helpful, which usually is reflected in the sys(3054)-output. Have you found constellations where this is not the case ? If so, any special pattern to watch out for ?
>
>regards
>
>thomas
Hi Thomas,
normally VFP create this temp index.
I remember to have seen cases where VFP uses a Cartesian product with an outer join;
I cannot say because this is not true for the Naomi's select, but it can to be one of these.
The uses of char pk and fk doesn't help because it open many setting conditions
( codepages, collation, set ansi ... ) and then more bugs can to be present;
I use integer pk only on local table or cursor.
regards
Fabio