How optimize queries with fully qualified names in t-sql?
- by tomaszs
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?
