Create an Index on AGENT and use HINT Clause in the SQL.