Re: Poor performance after upgrade from Online 7.1 to 7.23

In article <6j0de2$2cm@news2.tds.net>, Robert Griffin <rag4@mead.com> writes >OPTCOMPIND is = to 0. What does that do? >David Williams wrote in message ... It favours the use of indexes over dynamic hash joins i.e. sequential scans of tables. >>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.. >> >>>Vic >>> >>>Robert Griffin wrote: >>> >>>> Greetings, >>>> > > > -- David Williams Maintainer of the Informix FAQ Primary site (Beta Version) http://www.smooth1.demon.co.uk Official site http://www.iiug.org/techinfo/faq/faq_top.html I see you standin', Standin' on your own, It's such a lonely place for you, For you to be If you need a shoulder, Or if you need a friend, I'll be here standing, Until the bitter end... So don't chastise me Or think I, I mean you harm... All I ever wanted Was for you To know that I care