Generally, how does performance of queries across multiple databases compare to a query on many tables in the same database? We are considering creating a separate database with its own tables that logically should be separate, but at times we will need to run a query (with joins) across the two databases. Is there a big performance hit for this?
Thanks,
Ron