Re: update statistics not recommended!

Greg Moye wrote: > > Neil Truby wrote: > > . . . snip snip . . . > Generally, Informix' optimizer does a *great* job if it has good stats, > and just awful otherwise (I doubt Informix puts much effort into > optimizing in the face of poor to nonexistant stats...there's no good > reason to). > > Sounds like a Oracle rule based optimizer mentality at work to me. Was > this package first or primarily written for Oracle or some other rule > based critter?? Sheesh, this is 1998, last I checked. > I believe that Informix is their 'database of choice' actually, but they support Oracle and Sybase, plus their own flat-file database -- LADB. John Carlson Informix DBA WH Smith, Inc.