SQL Query with Tables from Two Databases in Same Server

I have a query that uses tables from two different databases in the same server. Is there any serious performance overhead or degradation with this setup? Would the query run significantly faster if all the tables were placed in only one database?

Your helpful insights would be greatly appreciated. Thanks in advance!

Not typically, unless one db was particularly busy or was encrypted or had some other inherent thing that would slow it down.

1 Like