Indexing on Subscriber

Question

I want to create index directly on subscriber in azure sql replication. Is it possible to do it without affecting the Publisher?

Answer 1

Hi Utkarsh upadhyay •,

Welcome to Microsoft Q&A forum.

As I understand, you want to create Index on Subscriber in Replication.

Indexes on SQL Server can be added at the Publisher or Subscribers with no special considerations for replication (be aware that indexes can affect performance). CREATE INDEX and ALTER INDEX are not replicated, so if you add or change an index at, for example, the Publisher, you must make the same addition or change at the Subscriber if you want it reflected there.

Could you please let us know what steps you are performing, is it for Azure SQL DB, SQL Server, Azure SQL Managed Instance?

Thanks

Answer 2

Hi Utkarsh upadhyay •,

Please refer to similar question here which should help:https://learn.microsoft.com/en-us/answers/questions/1030326/replication-of-non-clustered-index-from-publisher

Let us know if your ask is the same.

If not, could you please explain more.

Thanks