Well, if you are writing a RLA program to return what could be solved with
select state, count(*)
from custmast
group by state
order by state
I'd argue that you'd actually get better performance by using SQL. I know
that sounds like heresy to the RLA crowd but I think Luis and I have
explained how sql would use the index only access and not have to buffer
all those columns not used.
Rob Berendt