Re: Informix Optimizer Question

In article <344CB7E6.6A3C@sympatico.ca>, jwoodger@sympatico.ca says... >' if the table has a small number of rows, the database will often find >it faster to simply scan the entire table and not bother using the >index. The exact number of rows where an index is unnecessary varies by >database product and the number of table columns but the cutoff is >usually somewhere in the 100-500 row range. Size of row plays a part, also; looking at 100 1000-byte rows is going to be a lot slower than 500 15-byte row, because more 15-byte rows will be scooped up by the engine on a single disk read. -- William Harris william@carsinfo.com Check out the NAGS spam filter. http://www.nags.org