Re: Sequential Scan on TEMP table

Posted in 2006

donsem — 7 Aug 2006 06:34:52 -0700 — source: Usenet: comp.databases.informix

A reader e-mailed me with a suggestion that worked. Our OPTCOMPIND was set to 2 on our test system. I changed it to 0 and the performance problem cleared up. Weird thing was this setting was 2 on our old test system running Informix 7.3 and we didn't have a performance problem on that machine. The other weird thing, is the answer came from someone in the Richmond, Virginia area, which is where I'm located. Small world indeed. :-) Thanks, don Don Semmens donsem@comcast.net