I added it yesterday and had thought its absence was the reason for the slow query, but it appears it is the "IN" syntax.

>This may have been mentioned already, but is there an index on agent_num?
>
>