Re: understanding On-Line's Optimizer

On 19 Dec 96 at 10:05, Steve Romankiw wrote: > I am new the Informix On-Line engine. I am looking for information on > On-Line v7.13 Cost Based Optimizer. We are migrating to Informix from > SQLBase and the optimizers work differently. In informix, we often get > sequential scans on queries that we feel should be using an index. Check that you've run UPDATE STATISTICS recently and regularly - and look it up in TFM. -- Ciao, Billy I'd be in favour of apathy, but I just couldn't be bothered...