The performance on Publisher db is acceptable but the Subscriber db is very poor. Please advise how can I mitigate this issue? As we understand the evolving reporting needs we can later fine tune and tune the performance. For now,
Will setting the following article properties act as a quick solution?
copy clustered index: Default-true
copy non clustered indexes: true
copy unique key constraints: Default-true
copy user-defined statistics: true
copy full text indexes: true ( please provide explanation)
View Complete Post