Simple Question. I’d like to add some indexes to the SYS_ATTR_VALUE table to allow more performance on searches against Dynamic Attribute values. The issue I see is that STRING_VALUE is a varchar(max) and can’t be given an effective index. I don’t need this length, can I change it? Or is there another suggested approach to improve searching performance against this table?
Thanks.