NOW-DSC-DOMAIN_PERFORMANCE_INEFFICIENT_QUERIES | |
---|---|
Severity | Warning |
Root Cause |
The audit will provide this warning if it finds more than 1000 slow queries in the sys_query_pattern table. A slow query is defined as having over 100 occurrences of the SQL "LIKE" construct in a single query statement. A high number of "LIKE" clauses in a single statement may be caused by the definition of too many Domain Contains, User Visibility, or Group Visibility relationship. |
Effect | Inefficient queries can cause performance delays. |
Corrective Action |
Contact Customer Support to remediate inefficient queries and clean up relationships within Domain Contains, User Visibility, and Group Visibility. Provide audit details to customer support, if possible:
|