Home » SQL & PL/SQL » SQL & PL/SQL » Update Statement Performance Issue (Oracle 10g)
Update Statement Performance Issue [message #346871] Tue, 09 September 2008 23:45 Go to next message
someswar1
Messages: 53
Registered: January 2008
Member
Can Any one tell me which hints r very usefull to update statement.

I have a table which have 22 m data and want to update one column.

UPDATE DIM_KEN_SUBSCRIBER_HLR SET STATUS_KEY=
NVL(KEN_GET_SUBSCRIBER_STATUS_KEY(SERVED_IMSI),'-99');

UPDATE DIM_SUBS_SERVICE_HLR
SET STATUS_KEY = '3'
WHERE SERVED_MSISDN IN (SELECT /*+ FIRST_ROWS(100) */ SERVED_MSISDN FROM DIM_SUBS_SERVICE_HLR
WHERE HLR_SERVICE_ID_KEY IN ('15', '19', '105')
AND SERVICE_ID_VALUE = '1');
COMMIT;
I am analyze the table to before update it.
I have creatting index SERVED_MSISDN,SERVED_IMSI,SERVICE_ID_VALUE,STATUS_KEY.

Can u tell me how i improc=ve performance to update statement.Plz Help
Re: Update Statement Performance Issue [message #346874 is a reply to message #346871] Tue, 09 September 2008 23:53 Go to previous messageGo to next message
BlackSwan
Messages: 25036
Registered: January 2009
Location: SoCal
Senior Member
http://www.orafaq.com/forum/t/88153/0/
Please read & FOLLOW the Posting Guidelines as stated in URL above

Re: Update Statement Performance Issue [message #346887 is a reply to message #346871] Wed, 10 September 2008 00:45 Go to previous message
dwarak.k
Messages: 61
Registered: June 2008
Location: Hyderabad
Member
Thomas Kyte has explained
http://asktom.oracle.com/pls/asktom/f?p=100:11:2157729209183848::::P11_QUESTION_ID:6407993912330

HTH
Previous Topic: Table Sizing
Next Topic: what's the difference in terms of result
Goto Forum:
  


Current Time: Sun Dec 04 10:55:06 CST 2016

Total time taken to generate the page: 0.05824 seconds