Posted by John Bell on 12/05/26 11:36

Hi

There should be no noticable loss if any, although in your example as you
are only selecting from the one table it is not necessary for any reference.
You may want to look at using a table alias which will save typing and also
(probably) make the statement clearer.

John

"serge" <sergea@nospam.ehmail.com> wrote in message
news:Aykvf.640$vN4.421703@wagner.videotron.net...
>I am doing a mass update of our SQL script files by adding dbo.
> to all references to the tables.
>
> The code is also adding dbo. in front of existing lines of code
> that are like this:
>
> SELECT CLIENT.FIRSTNAME,
> CLIENT.LASTNAME
> FROM CLIENT
> ...
>
> The mass update is causing this to become:
>
> SELECT dbo.CLIENT.FIRSTNAME,
> dbo.CLIENT.LASTNAME
> FROM dbo.CLIENT
> ...
>
> My goal is to see FROM dbo.CLIENT
> but even the column names are getting the "dbo."
> added, so my question is if there's any performance
> loss or any other side effect if I end up all my columns
> with a preceeding "dbo."?
>
> Thank you
>
>

[Back to original message]