Thank you runrig and tye for your responses. tye, your suggestion worked for me as I updated the query and the used rows on it to get the count which this time was actual rows that were changed. I think this improved performance of my query as well. Thanks again.

Updating subject as solved.