Clustered Primary Key | Community
Skip to main content
New Member
March 9, 2022
Question

Clustered Primary Key

  • March 9, 2022
  • 0 replies
  • 562 views

For background, we're using Campaign Classic V7 with a fully on-premise architecture. In the documentation for data model 'best practices' it states this:

For SQLServer database, you could consider using “clustered index” if performance is needed. Since Adobe does not handle this, you need to create it in SQL.

 

I added a clustered primary key via SQL to the NmsRecipient table and performance improved as expected. Great. The problem, however, is when I run the "Update database structure...", it always wants to drop the index because it's not defined anywhere in the XML I guess. 

 

Is there anyway to avoid that? I'd imagine if the documentation says to create in SQL then there has to be some way of atleast making the system accept\ignore whatever you deployed directly via SQL. Anyone have any idea how to do that???

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.