>>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?
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.