Re: Question about cost estimated by Informix engine

Leonid Vorontsov wrote: > > Hi, All! > I didn't receive any comments or suggestions about subj NVARCHAR posted > by me sometime ago. Sorry... But OK, life continues. Next question. > I have ODS for NT and simple query: [SNIP] Set OPTCOMPIND=0 in your ONCONFIG file and those nasty NESTED LOOP joins go away in favor of indexes. Make sure you have indexes that begin with the key join columns on each table and that statistics are updated according to the suggesions in the release notes. As to the estimated costs, there is a known problem with those values that is under investigation, but with OPTCOMPIND=0 you should see more sensible values anyway. Art S. Kagel