I recently started replication on my server. Starting out, the publisher and subscriber tables were indexed indentically, but I soon noticed that when my subscription job runs (each hour), it completely wipes out the indexes in all the subscription tables. I have replaced the indexes several times only to find them gone soon after.
I thought about running a script to run each hour to re-index each table after it subscribes, but that seems clumsy. Is there any other way to retain the indexes from the publisher in the subscriber?