RE: Difference between Select and Omit in LF

Fred,

I noticed that also, but the resulting number of records is exactly the
same for both files.  Makes you wonder where that difference in index size
comes from (back to the books!)

Thanks,

Peter



funderwood@xxxxxxxxxxxxxxxxxxxxxxxxxx
Sent by: rpg400-l-bounces@xxxxxxxxxxxx
12/05/2004 15:38
Please respond to
RPG programming on the AS400 / iSeries <rpg400-l@xxxxxxxxxxxx>


To
RPG programming on the AS400 / iSeries <rpg400-l@xxxxxxxxxxxx>
cc

Subject
RE: Difference between Select and Omit in LF






Hi Peter,

Could this be the difference:

Index size  . . . . . . . . . . . . . . :                    1056768

vs:

Index size  . . . . . . . . . . . . . . :                      24576


Seems like the 'omit' version has a lot less data to index or process.


Fred Underwood
North American Stainless
(502) 347-6187

mailto:funderwood@xxxxxxxxxxxxxxxxxxxxxxxxxx





The information contained in this communication is confidential and may be 
legally privileged. It is intended solely for the use of the individual or the 
entity to whom it is addressed and others authorised to receive it. If you have 
received it by mistake, please let the sender know by e-mail reply and delete 
it from your system.
If you are not the intended recipient you are hereby notified that any 
disclosure, copying, distribution or taking any action in reliance of the 
contents of this information is strictly prohibited and may be unlawful.
Honda Europe NV is neither liable for the proper and complete transmission of 
the information contained in this communication nor for any delay in its 
receipt.