Post reply

Using .. in object identifiers

  • July 15, 2010 at 1:24 pm

    #224854

    I have inherited a very large DB (1.2TB) and am supposed to look for ways to optimize it.

    Many of the stored procedures and functions refer to tables using double dots in place of the schema name. ie. db01..table02

    I can see why they would do that from a programming point of view, but what are the performance implications? Does it take longer to resolve these identifiers when creating the plan, or is it about the same?

    I have only been able to find one reference to the use of double dots in the MS books online and that only mentions that it is valid syntax.

    Any input on this would be helpful.

    Thanks!

    Jerry

  • July 15, 2010 at 3:06 pm

    #1193793

    Skipping the schema by using two dots just tells the server to use the default schema (usually dbo). AFAIK, there is no efficiency gain by using this, I think it's just a faster way to write a qualified name - as long as you are ok with the default schema being used.

    _________________________________
    seth delconte
    http://sqlkeys.com

  • July 15, 2010 at 3:16 pm

    #1193796

    Sounds good. Just wanted to be sure.

    Thanks!

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply