>>>Index your Employee_Queue_Schedules by iActive_Flag and see if this speed this SELECT up. I hope you have index by cTrans_Employees_Queues_fk in Employee_Queue_Schedules.
>>
>>I don't want to add an index on this integer field which has only 1 and 0 values.
>>
>>We have indexes on every fk and pk.
>
>Then why no optimisation for this table?
Because it doesn't participate in WHERE condition.
If it's not broken, fix it until it is.
My Blog