SQL Server Performance Forum – Threads Archive

Joining tables across databases

Will sql server uses any indexes when tables are joined across databases on the same server? Are there any other performance considerations? Thanks Daniel Reber
Datamasters, Inc Daniel Reber
Datamasters, Inc

---

Yes, indexes will be used. This is easy to test by examining the execution plans, if you have not tried it before. There is a very minimal performance hit, but I doubt if you would be able to notice it. ——————
Brad M. McGehee
Webmaster
SQL-Server-Performance.Com

---

Thanks Brad. Daniel Reber
Datamasters, Inc

---

]]>