Hi,
Does Microsoft recommend/support to create non-clustered index in distribution database table Msrepl_commands? Our informatica CDC queries is running longer and execution plan suggest 99% impact to create missing non-clustered index. Once we created the non-clustered index the perf issue stand fixed but double checking if Microsoft support creating indexes in system databases?
Thanks,
-SreejitG