IsNull vs Coalesce Speed test
in a forum i said i once did a test on isnull and coalesce speed test but i haven't documented it. so i did it again. results in articles under test ... :)
or here
Legacy Comments
|
Anatoly Lubarsky
2004-11-24 |
re: IsNull vs Coalesce Speed test Isnull is faster: http://blogs.x2line.com/al/archive/2004/03/01/189.aspx |
|
Mladen
2004-11-24 |
re: IsNull vs Coalesce Speed test well try my code on your machine and tell me the results... maybe the difference is in that you use it in the where and i used it in the select. but i sure would like to know how the isnull works inside. |
|
Tara
2004-12-02 |
re: IsNull vs Coalesce Speed test I wonder why my link to Adam's test got deleted. |
|
Tara
2004-12-02 |
re: IsNull vs Coalesce Speed test Nevermind. I see I posted it in the actual article. |
|
Mladen
2004-12-02 |
re: IsNull vs Coalesce Speed test thanx tara... |
|
Jerry Nixon
2006-05-24 |
re: IsNull vs Coalesce Speed test I found IsNull() is the fastest option. http://jerrytech.blogspot.com/2006/05/sql-2k-performance-isnull-vs-coalesce.html |
|
samples
2008-04-10 |
re: IsNull vs Coalesce Speed test thanks.. |