Re: Question about cost estimated by Informix engine

Art S. Kagel wrote: +> Set OPTCOMPIND=0 in your ONCONFIG file and those nasty NESTED LOOP +> joins go away in favor of indexes. NESTED LOOP joins *are* index joins, typically. It means you read one table, by an index if possible, then use values from each row read from that table to do an index lookup into the second table, and so on. Perhaps you mean to avoid HASH JOINS? -- Dave Kosenko davek@summitdata.com Director of Training Services (732) 469-4070 Summit Data Group (an Informix Authorized Education Center)