| Assembly | SqlServer.Rules.dll |
| Namespace | SqlServer.Rules.Performance |
| Class | UseExistenceInsteadOfCountRule |
| Id | SRP0023 |
| Friendly Name | Enumerating for existence check |
| Category | Performance |
| Ignorable | true |
| Applicable Types | Procedure |
| Scalar Function | |
| Table Valued Function |
When checking for existence use EXISTS instead of COUNT
Consider using EXISTS instead of COUNT