Re: Poor performance after upgrade from Online 7.1 to 7.23

David Williams <djw@smooth1.demon.co.uk> wrote: >In article <35520AA3.557581C1@cornell.edu>, Vic Goldberg ><vg19@cornell.edu> writes >>Check in the Administrator's guide, volume 2 - in the back, there's a section >>on >>oncheck. >> > Also check OPTCOMPIND=0 in your ONCONFIG file.. > I'm running 7.20.UC3. Recently I discovered a slow-performing sql which wasn't using an index. Looking at it simplistically, I expected it to use an available index. 'Update statistics' is run nightly against this slowly changing table. I had OPTCOMPIND=2, but didn't pay any attention to it. Informix support suggested OPTCOMPIND=0. I made the change, re-ran the sql - now it uses the index and is fast. Haven't noticed other sql being adversely affected by this change. ---------------------------- Weight is the result of friction between mass & gravity. My *real* .sig awaits future display technology (sent with Agent 1.5/32)