>>>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
>
>The results are really strange, since we have indexes on all FK/PK. We're using GUID for our PKs. AFAIK all indexes are created with MACHINE collate.
check cpdbf()=cpcurrent()