appears as though you would get partial...

what is your setting for:

set('deleted')

*-- if set deleted on
do you have index on deleted() in your trans_employees_queues table?




>Also while you're at, do you know why I get

>SELECT Trans_Employees_Queues.cTrans_Employees_Queues_pk , ;
>Trans_Employees_Queues.cCommission_Owner_UsGrLink_fk as cUsGrlink_pk ;
>FROM Trans_Employees_Queues ;
>INNER JOIN Employee_queue_schedules ;
>ON Trans_employees_queues.cTrans_employees_queues_pk = ;
>Employee_queue_schedules.cTrans_employees_queues_fk ;
>inner join Trans on Trans_Employees_Queues.cTrans_fk = Trans.cTrans_pk ;
>WHERE 	 Trans_Employees_Queues.iActive_Flag = 1 ;
>	 AND Employee_queue_schedules.tScheduled_time <= {^2006-05-03 23:59:59} ;
>    AND Employee_queue_schedules.iActive_Flag = 1 ;
>    and Trans.cResolution_Codes_fk is NULL ;
>	
>
>&tcSql
>Rushmore optimization level for table trans_employees_queues: none
>Using index tag Tschedtime to rushmore optimize table employee_queue_schedules
>Rushmore optimization level for table employee_queue_schedules: partial
>Using index tag Crescod_fk to rushmore optimize table trans
>Rushmore optimization level for table trans: full
>Joining table trans and table trans_employees_queues using index tag Ctrans_fk
>Joining intermediate result and table employee_queue_schedules using index tag Cempque_fk

>
>despite the fact I have binary indexes on iActive_Flag = 1 in both tables where I use this condition?