PiMané (10/1/2014)
How does SQL handle cross database statistics? Would it be better instead of using directly the tables on other databases use a synonym or that doesn't make any difference?
To the best of my knowledge it doesn't matter. As long as permissions are correct statistics are handled the same. The only thing you miss out on is the optimization you can get with foreign keys, but that would be there even with synonyms.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question