Re: Update takes insanely long time
Date: Fri, 10 Dec 1999 10:30:58 GMT
Message-ID: <82qkp3$kv8$1_at_nnrp1.deja.com>
Tapan,
It sure sounds like there's an AFTER UPDATE database trigger on
this table that is resetting column1 to 'Y', causing an endless loop.
Hope this helps,
Paul
In article <38503306.44249857_at_abbnm.com>,
Tapan Trivedi <tapan.trivedi_at_abbnm.com> wrote:
> Hi gurus,
> 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
>
> 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
> Will be grateful if you could reply to the e-mail address also.
>
>
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Fri Dec 10 1999 - 11:30:58 CET