PE013
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.
This documentation contains proprietary information and is protected by copyright law.
Copyright © 2026 Red Gate Software Limited. All rights reserved
