>>select top 105 trans.cTrans_pk, ; >>NVL(Employee_Queue_Schedules.tScheduled_Time, {^3000-01-01 00:00:00}) as tScheduled_Time, ; >>Trans_Employees_Queues.cTrans_Employees_Queues_Pk, 0 as iAssigned, ; >>space(16) as cCommission_Owner_UsGrLink_fk, ; >>space(16) as cQueue_names_fk ; >>from trans INNER join Trans_Employees_Queues ; >>on trans.cTrans_pk = Trans_Employees_Queues.cTrans_fk ; >>LEFT JOIN Employee_Queue_Schedules ON ; >>Trans_Employees_Queues.cTrans_Employees_Queues_pk = ; >>Employee_Queue_Schedules.cTrans_Employees_Queues_fk ; >>and Employee_Queue_Schedules.iActive_Flag = 1 ; >> ; >>where Trans_Employees_Queues.cCommission_Owner_UsGrLink_fk IS NULL ; >>and Trans_Employees_Queues.cQueue_names_fk = '5776CF7543564793' ; >>and trans.cDepartment_Code like 'O' ; >>and trans.cResolution_Codes_fk is NULL ; >>and Trans.iAccount_locked_flag = 0 ; >>and between(trans.yCurrent_Balance_Amount, 0.0100, 499.9900) ; >>and Trans_Employees_Queues.iActive_Flag = 1 ; >>AND Trans.cProduct_Line_Code BETWEEN "600" AND "604" ; >>AND tExpire_date < {^2006-06-20} order by tScheduled_Time, tDate_Received>>
>index ON cTrans_Employees_Queues_fk IN Employee_Queue_Schedules >This index exists. We always have indexes on FK and PK.