On 30 Oct 98, at 3:49, justabill wrote:
> I am doing a two table join and I want to know if there is a way I can get
> informix 7.23 not to use the indexes. The reason is because I know that
> the join will return close to 100% of the rows so I want to see if the
> dynamix hash join might be faster than using the index. Is there any way
> to tell informix not to use the index?
Set OPTCOMPIND to 2 in your onconfig file. Make sure you've run
all the variations of UPDATE STATISTICS that are needed, and the
engine should work it out for itself. :-)
HTH.
--
Ciao,
Billy
/Group Managing Director, The West Solutions Group: http://www.west.co.za
\\ Drivel @ http://www.west.co.za/tasteless/
/
\\ "Granted, Mr Wheeler's ideas are stupid and unreasonable, but he does own the company and I
/ think we should go along with him..."
\\________________________________________________________________________________________________