variables and speed

• peloke

  SSC-Addicted

  Points: 409

  More actions

  May 28, 2002 at 1:25 pm

  #78764

  I have a select statement that has many 'ands' where one side uses the same thing for ex.

  where

  t1.column1=r3.other and

  t1.column1=e5.new and

  t1.column1=k9.old etc...is there any speed gained by putting the value for column one into a variable and using that variable each time instead of t1.columns1?

  Thanks,

  Eddie

• nagdimunovd

  SSC-Addicted

  Points: 496

  More actions

  May 28, 2002 at 2:55 pm

  #429856

  Can you ellaborate on your problem.

  Thanx Dan

  quote:

  ---

  I have a select statement that has many 'ands' where one side uses the same thing for ex.

  where

  t1.column1=r3.other and

  t1.column1=e5.new and

  t1.column1=k9.old etc...is there any speed gained by putting the value for column one into a variable and using that variable each time instead of t1.columns1?

  Thanks,

  Eddie

  ---