Answer the question
In order to leave comments, you need to log in
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
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question