Home Forums SQL Server 7,2000 T-SQL Is NULL comparison slow? RE: Is NULL comparison slow?
Antares686
SSC Guru
Points: 125444
More actions
May 19, 2003 at 2:46 pm
#457702
Try this
AND (CASE WHEN ErrorID >= @ErrNumStart OR @ErrNumStart Is Null THEN 1 ELSE 0 END) = 1
I am just curious what effect it has. Is the code in an SP and have you looked at the execution plan to see how compares without the line.