After db restore on Subscriber server, i configured transaction replication SQLServer 2005. then later few tables were added with Primary Key so that they can be part of replication, i ran the snapshot and everything went fine. When a bulk load test happend the process was too long, after investigation, i found the subscriber tables are not having the primary Keys, and it was doing full table scan.
I am bit confused here, how my Primary Keys are missing in Subscriber tables, which seems to me very odd. Any help or pointers would be much appreciated. Thanks...
Answer by Steve Jones - Editor ·
If you had primary keys on the publisher tables from the start, they should have been put through when the tables were created on the subscriber. Did you let replication create the subscribed tables or were they manually created?