variables and speed

  • 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

  • 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


Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply