Re: slow update table

A dbschema -d <db> -t <yourtable> -ss would help; maybe you have triggers defined on it?? also a set explain on; -- may be with a hint avoid_execute to see what the query planis.. what about the lock mode is it set and if so is it set to indefinite?? when you unload it and reload in a test system how long does it take there?? Superboer. "Ian M. Jones" <ian@imij.co.uk> wrote in message news:<1100205523.OzkZMpHGBCj0ZZ3YoqQu4Q@teranews>... > Is your system still usable/being used ok by other users/processes? > > Are your logs backing up quick enough, i.e. "onstat -l" shows plenty of > logs with the "B" flag set? > > Regards, > > Ian Jones > > On 11 Nov 2004, at 15:23, Steven Kurlander wrote: > > > Hello, > > > > We are running the following query (with no where clause): > > > > update tablename set columnname = 'BA'> > > > The table has about 300,000 rows and the update is taking days. We do > > not have an index on this column. Can anyone offer suggestions as > > what we should do? > > > > The system is Informix Dynamic Server 9.3 running on an E3000 with > > Solaris 8. > > > > Thanks, > > Steve Kurlander > > > ________________________________________ > http://www.imij.co.uk > > sending to informix-list