Home » SQL & PL/SQL » SQL & PL/SQL » Update query taking long time (10.2.0.3.0)
Update query taking long time [message #398166] Wed, 15 April 2009 08:05 Go to next message
user71408
Messages: 585
Registered: November 2007
Location: NE
Senior Member

Hi All,

I have executed the following Update query. But It is running from last more than 30 mins. can any one please look into this.
UPDATE gold_post
   SET apn_gprs = 'Y',
       apn_internet = 'X'
 WHERE id_top IN ('1.809961', '1.647192', '1.1396202')
 AND tariff_code IN (169, 135, 136);


Thank you
Re: Update query taking long time [message #398172 is a reply to message #398166] Wed, 15 April 2009 08:39 Go to previous message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Could you have a look at forum guide and performances sticky.

Thank you
Michel
Previous Topic: Getting Terminal Id(Machine Name)in Database Trigger Executing in Application Server Environment
Next Topic: Update statement
Goto Forum:
  


Current Time: Fri Dec 09 00:16:31 CST 2016

Total time taken to generate the page: 0.18780 seconds