SQL Server Performance

Joining tables across databases

Discussion in 'T-SQL Performance Tuning for Developers' started by danielreber, Mar 13, 2003.

  1. danielreber New Member

    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
    danielreber, Mar 13, 2003
    #2

  2. bradmcgehee New Member

    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
    bradmcgehee, Mar 13, 2003
    #2

  3. danielreber New Member

    Thanks Brad.

    Daniel Reber
    Datamasters, Inc
    danielreber, Mar 14, 2003
    #2

Share This Page