Re: Memory Allocation Question

[Rich Duzenbury <rduz-midrange@xxxxxxxxxxxxxxxxxxx>]

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