aurato (11/15/2011)
jared-709193 (11/15/2011)
Now we understand your real concern. You don't want indexes there that are unused because you feel that it may affect performance. Let me ask you this... Are you seeing problems with performance on your inserts?Jared
When any large number of inserts or updates happens on the publication server, replication falls hours behind and kills report performance. I don't know if that's due to insert issues, though. I can't say that I've ever gone "Man that insert took way too long."
Just a PS. Insert can also suffer from LACK of indexes (check the exec plan for table scans for FK checks).