Index scan question

[Barry Wiseman]

Don Coleman wrote:

> Ken:
> 
> Yes, this file is archived each night, moving 80-90% of the records
> contained to an archive qualifier.  What you suggest now makes sense.  As
> the day goes on, the number of records being read is increasing, now over
> 40,000.  I tried adding another field to the selection set, 
> Field #1(8,*) gt "" (blank) but it still is reading all the records.  I also
> confirmed PFIXS=ON is in the environment.  What can I add to only read the
> records where field #11 is equal to ""(blank)?  This seems so simple yet ...

Suppose you create the records with 11="N" instead of blank?  Would 11 
eq N work any better/different in the selection table than 11 eq ""?