Published 20 November 2017
COUNT used instead of EXISTS
It is not recommended to use COUNT() in this circumstance. Use EXISTS() instead for superior performance and readability.
Some programmers use COUNT(*) to check to see if there are any rows that match some criteria when EXISTS() or NOT EXISTS() could be used instead.