Re: How to do Light Scans . . .

Posted in 2009

Topics: Performance & Tuning, Data Types & Schema Design

jack.parker4@verizon.net — Mon, 05 Jan 2009 15:38:38 -0600 (CST) — source: Usenet: comp.databases.informix

Most of the info that is not in the manuals I stole from the Master Series manual or made up. ;-) BTW. XPS will perform light scans against varchars. I know that light scans against varchars is a feature request, I believe I am the requestor. j. On Mon, Jan 5, 2009 at 2:18 PM, LIGHT SCANS wrote: > Hello Jack, Your link is great. It explains more about Light Scans than the Informix manuals. I wish that the IBM Informix Dynamic Server Performance Guide would have it, especially your formula for bufcnt! As to the varchars, you are probably right. I'm going to test it. Thanks, L.S. _______________________________________________ Informix-list mailing list Informix-list@iiug.org <mailto:Informix-list@iiug.org> <mailto:Informix-list@iiug.org> http://www.iiug.org/mailman/listinfo/informix-list <http://www.iiug.org/mailman/listinfo/informix-list>; <http://www.iiug.org/mailman/listinfo/informix-list>;

↪ replying to jack.parker4@verizon.net

LIGHT SCANS — Wed, 7 Jan 2009 08:23:42 -0800 (PST) — source: Usenet: comp.databases.informix

Besides Jack and me, has anyone else found new details on how to do LIGHT SCANS?