1 Reply Latest reply: Apr 17, 2013 9:29 AM by riedelme RSS

    query running slow

    963994
      Hi,
      I am running an update query which taking more time any help to run this fast.
      update arm538e_tmp t
      set t.qtr5 =(select (sum(nvl(m.net_sales_value,0))/1000) from
      mnthly_sales_actvty m
      where m.vndr#=t.vndr#
      and m.cust_type_cd=t.cust_type
      and m.yymm between 201301 and 201303
      group by m.vndr#,m.cust_type_cd;

      help will be appreciable
      thank you

      Edited by: 960991 on Apr 17, 2013 7:23 AM
        • 1. Re: query running slow
          riedelme
          960991 wrote:
          Hi,
          I am running an update query which taking more time any help to run this fast.
          update arm538e_tmp t
          set t.qtr5 =(select (sum(nvl(m.net_sales_value,0))/1000) from
          mnthly_sales_actvty m
          where m.vndr#=t.vndr#
          and m.cust_type_cd=t.cust_type
          and m.yymm between 201301 and 201303
          group by m.vndr#,m.cust_type_cd;

          help will be appreciable
          thank you

          Edited by: 960991 on Apr 17, 2013 7:23 AM
          Your question is a general Oracle issue that will happen in any environment. This forum is titled SQL Developer *(Not for general SQL/PL/SQL questions)*.

          You will get a better answer in less time if you close this thread and re-open it in the SQL forum PL/SQL