Re: Memory Allocation Question

[Tony Carolla <carolla@xxxxxxxxx>]

I didn't thoroughly read your reply the first time.  This sounds like
a great solution!  Now why didn't I think of this... Thanks!!!


On Tue, 09 Nov 2004 15:40:24 -0600, Rich Duzenbury
<rduz-midrange@xxxxxxxxxxxxxxxxxxx> wrote:
> On Tue, 2004-11-09 at 15:28, Tony Carolla wrote:
> > Thanks Rich.
> >
> > My second attempt (which I didn't tell about -- I was trying to avoid
> > a novel ;) did just that.  I made a discovery though, that over 50% of
> > people have the same ss# -- Zero.   
> Right, the SS index should not include records where the SS is 0, 0
> means not given.  Course on the systems I work on, the SS is required,
> so the bogus records have a SS# = 1.  Anyway, simply create the SS
> logical with a select/omit criteria, and only select those records that
> have an SS.  Same for birthdate, btw.
> 
> I think you will be able to save *many* I/O's and much processing time
> by using the three indexes idea.
> 
> --
> 
> 
> Regards,
> Rich
> 
> Current Conditions in Des Moines, IA
> Broken Clouds
> Temp 62.6F
> Winds out of the Southwest at 16mph
> 
> --
> This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.
> 
> 


-- 
"Enter any 11-digit prime number to continue..."