Re: Query Optimization: Wrong execution plan?

Posted in 2000

Obnoxio The Clown — Wed, 16 Aug 2000 12:00:00 BST — source: Informix-list mailing list archive (1991-1998)

From: Leonids.Voroncovs@dati.lv > >Xavi Tarafa Mercader wrote: > > > Any suggestion about how to improve the query performance? > >Set OPTCOMPIND parameter ( in onconfig file ) to 0. I'm not sure that will help. The query is going to probably scan both tables anyway, so a nested loop join would probably be slower overall. ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com