sql performance with queries referencing objects from another database

Question

I am curious to find out if there is a performance penalty accessing an object from another database on the same server vs accessing an object from the same database. For example, which one is faster

SELECT Anotherdb.dbo.GetFormattedData(@test)

OR

SELECT dbo.GetFormattedData(@test)

we are using sql server 2008.

You can use some sample data and test it

Lamak
– Lamak

2014-04-21 19:26:23 +00:00
Commented Apr 21, 2014 at 19:26 — Lamak
– Lamak, Commented Apr 21, 2014 at 19:26

rhealitycheck · Accepted Answer · 2014-04-21 20:32:25Z

1

There shouldn't be a performance difference if you are on the same server.

The only time you should see a notable change in performance is if you are using a linked server and actually accessing a database via linked server.

answered Apr 21, 2014 at 20:32

rhealitycheck

6603 gold badges8 silver badges19 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

sql performance with queries referencing objects from another database

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related