Re: Fast Update for a single field with Oracle 9

From: Emanuel Blaser <emanuelblaser_at_yahoo.com>
Date: 19 May 2004 12:51:42 -0700
Message-ID: <857de1e3.0405191151.48576810@posting.google.com>

Hi Jeremy,

I'm sorry there was a mistake, I didn't know that for this field a update trigger was created thats why it took so long :-).

Thanks anyway.
Emanuel

Jeremy <newspostings_at_hazelweb.co.uk> wrote in message news:<MPG.1b156c7b5e3a332989bfc_at_news.individual.net>...
> In article <857de1e3.0405190435.86dcbaf_at_posting.google.com>, Emanuel
> Blaser says...
> > Hello,
> >
> > I have to Update a Field with null (for all Rows). Update seems to me
> > a bit slow, is there any other way to do this?
> >
> You could drop the column and then add the column again. Sledgehammer to
> crack a nut though!
>
> Why is the update slow - how mahy rows/how long does it take? How many
> times might you have to repeat this process and with what frequency?
Received on Wed May 19 2004 - 14:51:42 CDT