SQL oddity

[Jim Langston <jlangston@xxxxxxxxxxx>]

I'm looking at a file, INP95 that has 277206 records and 10662 deleted
records.
STRSQL
select * from INP95 where URID95 = 'PRISM     '
I get a list of 14000 odd records, which is right.
I type B in the Position to line
It finally finishes after processing 41,552,000 odd records.  Where did the
other records come from, or just what in the world was SQL doing?

This was an adhoc query, so it probably doesn't matter, I'm just curious,
what records was SQL processing?

Regards,

Jim Langston