Indexing issue

Hi ,
Please help me can i create index on secondary machine for reporting but do not want that index on Primary . I am using Sql server2012.

I guess that depends on the set up of your secondary instance.

If you are log shipping, mirroring or using availability groups then I believe this cannot be done as all methods are creating a duplicate copy of your database including the schema.

If however your secondary instance is being populated by replication methods then I would suspect you can create indexes on the secondary as you are essentially only updating data through the replication methods.

Thanks for reply .. I will try this let you know , again thanks for reply.