Query Memory Usage?

• MissPukeyCow

  Ten Centuries

  Points: 1146

  More actions

  June 22, 2006 at 3:25 pm

  #153051

  Do you have any idea why the order of the conditions in the follow code would cause SqlServer's memory usage to rise from 20M to 200M ?

  declare  @UWI_Equals VARCHAR(13)

   set @uwi_equals = '0014010606000'

   

  SELECT *

  FROM [Well]

  WHERE

     ((UWI = @UWI_Equals) OR (@UWI_Equals Is Null) )  --   small memory usage: 20M

  --   ((@UWI_Equals Is Null) OR (UWI = @UWI_Equals))   -- big memory usage:  200M+

  ORDER BY UWI ASC

• Ray M

  SSC-Insane

  Points: 21093

  More actions

  June 22, 2006 at 7:38 pm

  #645421

  Dunno,

   

  Or perhaps

  SELECT *

  FROM [Well]

  WHERE UWI = @UWI_Equals)

    AND @UWI_Equals Is NOT Null

  get rid of the OR Operator should be good