Update takes insanely long time
Date: Thu, 09 Dec 1999 16:53:58 -0600
Message-ID: <38503306.44249857_at_abbnm.com>
[Quoted] Hi gurus,
[Quoted] [Quoted] I have a question for you all. One of my developers is trying to update a table with around 16500 records . She is trying a very simple update statement which goes like
update tablename set column1 = 'N' where column1 = 'Y' She has around 12500 records which will be affected. It has taken around 16 hours now for this simple operation. Other tables on the same instance do not have any problems for similar updates.
There were about 35 constraints on this table which I disable hoping
[Quoted] to do better this time without any success. Am I missing something
obvious ? Should I be
concerned about anything else ?? Any comments, suggestions , ideas will
be appreciated.
Tapan H Trivedi
[Quoted] Will be grateful if you could reply to the e-mail address also.
Received on Thu Dec 09 1999 - 23:53:58 CET