Re: Update takes insanely long time

Any triggers?

 Michael.

In article <38503AFA.713D7A2_at_lds.com>,
  Marc Weinsock <MWeinstock_at_lds.com> wrote:
> 1. Do U have an index on column1?
> 2. Did U analyze the table?
> 3. 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
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Dec 10 1999 - 06:27:55 CST