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



      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