January 26, 2012 at 10:45 am
Jeff Moden (1/26/2012)
Steve Jones - SSC Editor (1/25/2012)
True, you can use views of synonyms. That might work, although performance wouldn't be great.For dev/test, it's probably fine.
I've not experienced any noticiable slowdowns with inter-db synonyms or passthrough views. The code for them is evaluated in the execution plan as if they were a part of the original query much like an iTVF or derived table is. Are you sure you're not thinking of "Linked Servers" which would provide a slowdown?
I've had it vary by version, perhaps not an issue in 2008, but I have seen slowdowns in inserts/updates at times. I suspect it might be workload dependent, but it seems that the cross database queries sometimes don't seem to get the same performance when they're joining tables across databases.
January 26, 2012 at 1:58 pm
This is only for Test environment
Viewing 2 posts - 16 through 16 (of 16 total)
You must be logged in to reply to this topic. Login to reply