Adding Sum Index Field when does it populate?

Botz1213

I have added a sum field to a few keys on a table.

There were exisiting fields there my question is when does SQL go in and calculate the SIFT for the newly added field?

2013R2

Slawek_Guzek

Its the same when you modify normal index. When you save a table with modified SIFT definition corresponding SIFT view is dropped and recreated, along with clustered index on it.

Same happens when you import a fob with table defnition having different SIFT index structure than existing table.

In NAV 2015 / 2016 update occurs when you synchronise changes with tenant databases.

Later on SQL internally keeps clustered index on SIFT view updated. This is happenning as a part of any insert/modify/update operation which touches any record included in the view.