When you incrementally index entities with more than one primary key, the query uses an AND / OR statement to fetch records.

Here is an example: If (IDA = 1 AND IDB = 1) OR (IDA = 2 AND IDB = 2) OR...

You might encounter a performance issue when more than 64 parameters are supplied to queries of this type.

This issue appears to be specific to SQL Server versions earlier than SQL Server 2022.

To circumvent this problem, you must set this consul property:

For SAS Visual Investigator version 10.7, that property is available with a hot fix that was released on January 26, 2023.

For SAS Visual Investigator version 10.8, that property is available with a hot fix that was released on December 12, 2022.

Click the Hot Fix tab in this note to access the hot fix for this issue.

Operating System and Release Information

Viya on Linux: An update for this issue is available for SAS Viya 3.5. For instructions on how to access and apply software updates, see the Updating Your SAS Viya software section in the SAS Viya 3.5 for Linux Deployment Guide at

An update for this issue is available for SAS Visual Investigator 10.7. For instructions on how to access and apply these software updates, see the documentation links at the top of

An update for this issue is available for SAS Visual Investigator 10.7. For instructions on how to access and apply these software updates, see the documentation links at the top of

An update for this issue is available for SAS Visual Investigator 10.8. For instructions on how to access and apply these software updates, see the documentation links at the top of

An update for this issue is available for SAS Visual Investigator 10.8. For instructions on how to access and apply these software updates, see the documentation links at the top of