2 Replies Latest reply: Feb 12, 2015 7:55 AM by Srikanth P RSS

    Is it better to join in the sql statement or in qv ?

    Laura Sébille

      Hello everyone,

       

      Which solution is better for general performance ?

       

      1)

       

      A:

      LOAD

      id1,

      id;

      SELECT

      id1,

      id

      FROM TABLEA;

       

      LEFT JOIN (A)

      LOAD

      id

      lala;

      SELECT

      id, lala

      FROM TABLEB;

       

       

      2)

       

      LOAD

      id1, lala;

      SELECT

      id1, lala

      FROM TABLEA LEFT JOIN TABLEB on TABLEA.id=TABLEB=id;

       

       

       

      ?

       

      Thank you for your answer

      Have a good day

      Laura