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.