1 Reply Latest reply: Oct 29, 2014 3:19 PM by Steve Taylor RSS

    2 load scripts with "where" clause VS 1 load with IF field.

    Simon Brulotte

      What would load quicker theoretically:

       

       

      2 loads with a where clause on PORT_NO for XXX values showing field MKT_VALUE

       

      or

       

      1 load with an If(PORT_NO = XXX , MKT_VALUE)

       

       

      I am not concerned with memory, as it is relatively small table loaded.