Re: Light Scans

Posted in 1997

Melvin Mariney — Tue, 03 Jun 1997 15:34:39 GMT — source: Informix-list mailing list archive (1991-1998)

MarkDenham@aol.com wrote: >All > >Anybody know anything about light scans and if they are implemented in any >7.x or Universal server? > >I know that they exist in XPS. Light scans do exist in 7.x and Universal Server, but light scans will only be used if the table being read is larger than the buffers pool size and also the engine has to determine that the table will be read sequentially rather than using an index before light scans are used. -- Melvin Mariney, Informix DBA e-mail: melvin.mariney2@bridge.bellsouth.com