Home » SQL & PL/SQL » SQL & PL/SQL » Update query taking long time (
Update query taking long time [message #398166] Wed, 15 April 2009 08:05 Go to next message
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: 63920
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Could you have a look at forum guide and performances sticky.

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

Current Time: Tue Oct 25 05:22:30 CDT 2016

Total time taken to generate the page: 0.08430 seconds