Re: Update takes an insanely long time

In article <38502FDE.E3EDB5F1_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
> 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.
>
>

In addition to the things already mentioned, verify that there are no update triggers on the table doing something unwanted or inefficiently. Unless you have a constraint on the column being updated, I doubt that RI is the problem.

Also, check for locks when the update is running to make sure you aren't being blocked.

thanks,

dave

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Dec 13 1999 - 12:10:09 CST