Re: select without indexes?

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..." \\________________________________________________________________________________________________