2 Replies Latest reply: Sep 28, 2016 6:01 AM by Loi Tan Vo RSS

    Transfom performance from inner join of inner join in MS SQL

    Loi Tan Vo

      Hi,

       

      I have following sql-scripts like this

       

      select distinct

             m.garnr           as garnr,

             m1.garnr         as m1_garnr

       

      from m_table m

      inner join a_table a on m.key1_m_table  = a.key1_m_table

      inner join a_table a1 on a1.key2_a_table = a.key2_a_table

      inner join m_table m1 on m1.key1_m_table = a1.key1_m_table

       

       

      How to express performance in transform in QV?

       

      Thanks in advance

      Loi