Post reply

variables and speed

  • 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

  • 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

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

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