Update operations

The Sitecore Xdb Collection Update tool initiates several update operations. The update operations use the primary key to scan the relevant tables by ID in ascending order, if possible. Next operations are also supported.

The update operations are:

• deviceProfiles – Updates the shard key column in the device profile table. The value is calculated based on the device profile ID.
• deviceProfileFacets – Updates the shard key column in the device profile facets table. The value is calculated based on the device profile ID.
• contacts – Updates the shard key column in the contact, contact’s identifiers, contact’s facets, contact’s interactions, and interaction’s facets tables. The shard key value is calculated based on the contact ID for all these tables and should be the same for all contact-related data.
• contactIdentifierIndexes – Updates the shard key column for the contact identifier index table. The value is calculated based on the contact ID.
• contactPercentile - Updates the percentile column of the contact table. The value is calculated based on the contact ID.
• interactionPercentile - Updates the percentile column of the interaction table. The value is calculated based on the interaction ID.

The update operations are listed in the recommended run order.