Re: OPTMIZATION

Posted in 2000

Obnoxio The Clown — Mon, 24 Jul 2000 20:25:25 BST — source: Informix-list mailing list archive (1991-1998)

From: "Lewis, Keith A." <Lewis@timken.com> > >Some of our users use a package called Brio to query the Informix database. >Since we have migrated to IDS 7.31 FC4 some of their queries are not >choosing the optimial path. When I run these same queries with OPTMIZATION >set to first_rows they run much faster. The only problem is there is no >way >to add the 'set OPTMIZATION first_rows' statement to the query in Brio. Is >there any way to add this set parameter in the ODBC configuration or to >their userid? In your onconfig file, set "OPT_GOAL 0" and restart IDS. ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com