There shouldn't be that much difference as long as both db's are on the same
server. Certainly not enough to warrant copying the table to the other db.
Andrew J. Kelly
SQL Server MVP
"Matti" <xmrfyahoo.de> wrote in message
news:a4b6eb66.0307090541.4adb03a5posting.google.c om...> Hi,
> I have a more theoretic question:
> I have two huge tables (db1.dbo.table1 and db2.dbo.table2). I need to
> join them. Will the effort to join both tables be the same as if both
> tables were located in the same database? Maybe it even performs
> better when I copy db1.dbo.table1 to db2 before making the join.
> Can anybody answer my question?