I feel like I have read this before on here but I cannot seem to find it. We have an older file that has 50 million records in it and 10 million deleted records, we are going to get this cleaned up. We also have a program that does a setll and reade (both have keys) on it twice for each customer and then writes out a record for each customer. This was performing horribly, I did a copy file to a test library to get rid of the deleted records and ran the program and it performed well.
The question is I thought if you used a key on setll and reade it would skip all the deleted records, am I incorrect on this?
The question is I thought if you used a key on setll and reade it would skip all the deleted records, am I incorrect on this?
Comment