Hello Peggers,
Does anybody know a way to quickly see how many records there are in a table.
We tried:
for each {table-name}:
i = i + 1.
end.
display i.
and also tried :
select count(*) from {table-name}
But when you have a large db/table this can take a lot of time.
Is there a faster way to find out the number of records in a table?
Thnx already.
J
Does anybody know a way to quickly see how many records there are in a table.
We tried:
for each {table-name}:
i = i + 1.
end.
display i.
and also tried :
select count(*) from {table-name}
But when you have a large db/table this can take a lot of time.
Is there a faster way to find out the number of records in a table?
Thnx already.
J