Prev: Bug or feature?
Next: Building a string out of table columns values
From: Plamen Ratchev on 30 Mar 2010 16:28
No, there is no other way (besides replacing ISNULL with COALESCE, but that may be even slower). I do not think using
ISNULL in SELECT will prevent the optimizer to choose the correct plan.

--
Plamen Ratchev
http://www.SQLStudio.com
From: TheSQLGuru on 30 Mar 2010 22:48
Why don't you try a big query with and without and see?

--
Kevin G. Boles
Indicium Resources, Inc.
SQL Server MVP
kgboles a earthlink dt net


"tshad" <tfs(a)dslextreme.com> wrote in message
news:uUEY3s8zKHA.4384(a)TK2MSFTNGP06.phx.gbl...
> If I had a query with columns surrounded by IsNull, would that slow the
> query down?
>
> For example if I had something.like:
>
> SELECT Phone= ISNULL(e.Phone, m.Phone),
> Name = ISNULL(e.Name,m.Name)
> FROM Employees e
> LEFT JOIN Managers m
>
> Would that have an affect on the query?
>
> Thanks,
>
> Tom
>


First  |  Prev  | 
Pages: 1 2
Prev: Bug or feature?
Next: Building a string out of table columns values