Different Indexes in replicated DB

  • Can i have different index structers in replicated DB? Eg: Col1 as clustered in primary db but Col2 as clustered in replicated DB?

  • Yes. You can configure each publication to either duplicate indexes or not. Once subscribing, there is nothing stopping you creating different indexes directly on the subscriber.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply