Problem Note 68262: Poor indexing performance occurs with non-VARCHAR primary key types in Microsoft SQL Server tables
 |  |  |  |  |
The indexer service in SAS® Visual Investigator does not allow partitioning by numeric keys and uses strings instead. Using numeric keys causes queries to run for a long time, because the numeric keys must be converted to the VARCHAR data type.
A workaround is to copy the numeric column, convert it to the VARCHAR data type, and then use it as a primary key.
Click the Hot Fix tab in this note for a link to instructions about accessing and applying the software update.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Visual Investigator | Linux for x64 | 10.6 | Viya | ||
An update for this issue is available for SAS Visual Investigator 10.6. For instructions on how to access and apply these software updates, see the documentation links at the top of
https://tshf.sas.com/techsup/download/hotfix/HF2/Viya_VI_10_6_home.html#68262An update for this issue is available for SAS Visual Investigator 10.6. For instructions on how to access and apply these software updates, see the documentation links at the top of
https://tshf.sas.com/techsup/download/hotfix/HF2/Viya_VI_10_6_home.html#68262| Type: | Problem Note |
| Priority: | medium |
| Date Modified: | 2021-08-17 15:39:23 |
| Date Created: | 2021-08-17 08:24:24 |