Re: Index problems on v7.1

Posted in 1996

Greg Moye — Tue, 04 Jun 1996 17:50:37 -0700 — source: Informix-list mailing list archive (1991-1998)

Norrgren@aol.com wrote: > > Dear All, > > I seem to have a slight problem in forcing a SELECT down a specific index > when doing a "between" on a column ( where col_name > x and col_name < y ). > >snip... Which version of OnLine are you running? 7.12.xxx versions I think have a bug where seq scans get done where a perfectly good index is available. Make sure Update Statistics is fairly current for the table (and any it is joined to...) -- Greg Moye Electronic Data Systems Corp. - Plano TX