Re: [Q] Which is Optimizer ?

On 8 Sep 98, at 2:04, Ȳ'' wrote: > I'm Newbie in Informix. I wonder which informix use optimizer mode. > I know that Oracle use rule-base optimizing and cost-base optimzing. > Informix also use cost and rule-base optimizer ? Informix >=6.x only supports cost-based optimisation. The rule based optimiser was in earlier versions. If my rapidly fading memory is correct. -- 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..." \\________________________________________________________________________________________________