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