I am taking a look at a database where maintain SIFT index property on the key is set to yet, but it has no sum index fields.
This seems really strange to me. Can anyone think of why a setup might be this way?
I don't think it will impact writing performance negatively, but I'm not sure. Any ideas?
0
Answers
Think of it being unchecked if there is no sumindexfields.
My guess why it's checked by default is that people would add sumindexfields
but forget to check maintain index and SQL will do sum on actual table causing performance issues in large tables.
Independent Consultant/Developer
blog: https://dynamicsuser.net/nav/b/ara3n
Especially because when you open the indexes the first time (=with a new zup-file), you don't see the properties for SQL, so it is easy to forget to enable the MaintainSIFTIndex.
No PM,please use the forum. || May the <SOLVED>-attribute be in your title!
Where that becomes an issue is when a developer removes all SIFT levels but leaves the MaintainSIFTIndex property checked, and yu want to modify other SIFT levels or even disable a SIFT key. Be aware of these properties and use them the right way.
RIS Plus, LLC
No PM,please use the forum. || May the <SOLVED>-attribute be in your title!