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