Database Management
DPA Index Advisor shows incomplete and incorrect index recommendations when queries use NOT predicates in WHERE clause
In DPA, the Index Advisor generates index recommendations that do not show the actual column names and instead display generic expressions such as NOT or null, leading to unclear and technically incorrect index suggestions. The behavior is reproducible and has been identified as a known issue.
First published date
Last published date
Overview
DPA Index Advisor recommendations for certain queries may appear unclear and misleading. In queries where the WHERE clause used predicates such as NOT (c."IsDeleted") or checks for NULL on multiple date columns, the suggested index definitions do not include the corresponding column names. Instead, the recommendations show only the predicate expressions (for example, NOT) or the literal null in place of the actual column names used in the query filters.
This behavior occurs across multiple queries and is not limited to a single statement, leading to index recommendations that you may not reliably understand or implement.
Product section
Cause
This has been identified as a known issue in DPA 2025.4.
Resolution
SolarWinds Engineering is investigating this issue, and as of January 28, 2026, there are no workarounds. Watch this article for updates.