Re: Update takes insanely long time

From: Marc Weinsock <MWeinstock_at_lds.com>
Date: Thu, 09 Dec 1999 23:24:18 GMT
Message-ID: <38503AFA.713D7A2@lds.com>

Do U have an index on column1?
Did U analyze the table?
Are the constraints foreign keys?

Tapan Trivedi 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.

Marc Weinstock
Logical design Solutions

55 Broadway - 21st Floor
New York, New York 10006

Phone: 800.221.5327 x2136
Fax: 212-825-2245
E-Mail: MWeinstock_at_lds.com
Web: http://www.lds.com Received on Thu Dec 09 1999 - 17:24:18 CST