B
B
Boris the Animal2016-07-14 10:32:23
SQL
Boris the Animal, 2016-07-14 10:32:23

Does specifying the database schema in the table name give any advantage when compiling queries?

I'm talking about the benefits of, for example, faster lookup of a table by the SQL server, etc. Or is it all nonsense and there is no sense in specifying the scheme?
With: SELECT Id FROM dbo.TableName
Without: SELECT Id FROM TableName

Answer the question

In order to leave comments, you need to log in

1 answer(s)
A
Andrey Lastochkin, 2016-07-14
@Casper-SC

Doesn't affect speed.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question