Change MaintainSIFTIndex property for a key

poppinspoppins Member Posts: 647
Hi everyone,

I have a key in a table that is not used anymore.Both properties MaintainSIFTIndex and MaintainSQLIndex are set to Yes.
The SIFT index associated to this key is causing a performance problem on a customer database.
What shall I do about it?
I do not want to delete or deactivate the key.
If I set the property MaintainSIFTIndex to No, would it be a problem?
And is it necessary to set also MaintainSQLIndex to No?

Thanks in advance :smile:


Sign In or Register to comment.