How optimize queries with fully qualified names in t-sql?
Posted
by tomaszs
on Stack Overflow
See other posts from Stack Overflow
or by tomaszs
Published on 2010-04-19T10:49:09Z
Indexed on
2010/04/19
10:53 UTC
Read the original article
Hit count: 165
Whe I call:
select * from Database.dbo.Table where NAME = 'cat'
It takes:
200 ms
And when I change database to Database in Management Studio and call it without fully qualified name it's much faster:
select * from Table where NAME = 'cat'
It takes:
17 ms
Is there any way to make fully qualified queries faster without changing database?
© Stack Overflow or respective owner
