NOW-DSC-DOMAIN_PERFORMANCE_INEFFICIENT_QUERIESNOW-DSC-DOMAIN_PERFORMANCE_INEFFICIENT_QUERIESSeverityWarningRoot 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. EffectInefficient 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: Log onto your instance.Navigate to Domain Separation Center.Select the Warnings widget.Open the Inefficient Queries audit record.In the bottom left, click Copy Details. The contents of the audit record will be copied onto your clipboard.Paste those details into an incident to expedite customer support's ability to assess what's wrong.