Re: Update too slow !!!

Posted in 1998

Douglas Wilson — Tue, 28 Jul 1998 06:13:17 GMT — source: Informix-list mailing list archive (1991-1998)

On Fri, 24 Jul 1998 14:24:18 GMT, "Hung Phi" <hphi@amtelco.com> wrote: >update t1 > set col1 = 'A', > col2 = 0 >where t1.id in (select recid from t2) Did you do a 'set explain on' and get an 'sqexplain.out' file? Are the two tables actually in the same database, or is one of them a synonym for a table in another db? Did you update statistics? Good Luck, Douglas Wilson