Nothing wrong with that. I guess you simply forgot the index on Countryid in the usersinfo table.

Also, the script in that sequense qill not work, so maybe we are missing something else, but I doubt it.