Hi @ SQLServerBro,
> is there any way i can drop indexes on subscriber without affecting replication.
Drop indexes on subscriber will not affect replication.
Quote from MS document;
How do I add or change indexes on publication and subscription databases?
Indexes 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.
> Under what circumstances snapshot of a table should be taken, what are the scenarios?
When you need to initial your SQL Server replication, it will create a new snapshot of the table.
If the response is helpful, please click "Accept Answer" and upvote it, as this could help other community members looking for similar thread.