Change MaintainSIFTIndex property for a key

poppins

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

Marije_Brummel

Not quite sure what you mean. You say the key is not used anymore and it is causing issues. Why not just delete it?

poppins

Mark_Brummel wrote: »

Not quite sure what you mean. You say the key is not used anymore and it is causing issues. Why not just delete it?

I checked in NAV side and it is not used.But I am not sure about SQL...
Is deleting the key the only option?

Marije_Brummel

You have the options:

1. Delete the key
2. Disable the key
3. Disable Maintain SQL

In all three cases SQL will no longer maintain the index so option one seems best I guess.