Home » RDBMS Server » Performance Tuning » Tuning need for a large data (oracle 10G)
Tuning need for a large data [message #323854] Thu, 29 May 2008 14:48 Go to next message
gyankr
Messages: 11
Registered: January 2008
Junior Member
Hi experts,

Please help me to tune the below

update sq_product_description sqpd
        set (short_description
            ,long_description
            ,update_date
            ,update_source)=
    ( select ifl.short_description
            ,ifl.long_description
            ,sysdate
            ,'nancy'
     from if_nan_prod_l ifl
        ,if_parameters ip
   where sqpd.product_code = ifl.product_code
    and sqpd.locale_language =trim(ifl.LANGUAGE_CODE)
    and sqpd.locale_country  =ip.country_code
    and ip.interface_id='NAN')
            where exists (
            select  1
                from if_nan_prod_l ifl
                    ,if_parameters ip
            where sqpd.product_code = ifl.product_code
                    and sqpd.locale_language = trim(ifl.LANGUAGE_CODE)
                    and sqpd.locale_country =ip.country_code
                    and ip.interface_id='NAN'
                    and (sqpd.short_description <> ifl.short_description
                    or sqpd.long_description <> ifl.long_description
                        )
                    );

The explain plan is attached.

Regards,
Gyan

[Updated on: Thu, 29 May 2008 22:19] by Moderator

Report message to a moderator

Re: Tuning need for a large data [message #323864 is a reply to message #323854] Thu, 29 May 2008 19:57 Go to previous messageGo to next message
BlackSwan
Messages: 25033
Registered: January 2009
Location: SoCal
Senior Member
http://www.orafaq.com/forum/t/84315/74940/
which have you tried & what were the results
Re: Tuning need for a large data [message #323875 is a reply to message #323864] Thu, 29 May 2008 22:21 Go to previous message
rleishman
Messages: 3724
Registered: October 2005
Location: Melbourne, Australia
Senior Member
See this article - scroll down until you get to the section on UPDATEs.

Ross Leishman
Previous Topic: optimizer_index_cost_adj
Next Topic: Metric Critical Alert - should I care?
Goto Forum:
  


Current Time: Sat Dec 03 12:24:39 CST 2016

Total time taken to generate the page: 0.05282 seconds