Re: understanding On-Line's Optimizer

sromankiw@execrisk.com (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. :Do you know of any books or white papers on the subject? You may start out by checking your manuals on update statistics and the set explain on statement. Nils.Myklebust@idg.no NM Data AS, P.O.Box 9090 Gronland, N-0133 Oslo, Norway My opinions are those of my company The Informix FAQ is at http://www.iiug.org