Improve select query performance
A composite index on (status, empID) will be faster.  It might be better as (empID, status) depending on the cardinality of these two columns.  An EXPLAIN would have shown you that it was only using one value against one index.