Re: slow update table
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