RE: Slowness

Posted in 2000

Obnoxio The Clown — Fri, 16 Jun 2000 13:28:01 BST — source: Informix-list mailing list archive (1991-1998)

From: "COOPER, Joseph" <Joseph.COOPER@sema.co.uk> > >I mainly read this to see what your comments would be because I had already >replied but this is priceless :-)))) > > > >OPTCOMPIND 2 # To hint the optimizer> > > > If this is an OLTP system, try setting this to 2. Thank you, Eagle Eye Cherry. That should, of course, have been 0, not 2. ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com