Kbase P96849: How to check how many records in a table ?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
8/2/2005 |
|
Status: Unverified
GOAL:
How to check how many records in a table ?
GOAL:
How to determine how many records are in a table ?
GOAL:
How can I tell how many records are in a table ?
GOAL:
Is there a way to get a quick count of records for a table ?
FIX:
There are two methods to accomplish this:
1.) Run the following code from the procedure editor, SQL Explorer or another ODBC compliant application:
select count (*) from owner.tablename2.) The number of records in a table is reported in the output of the PROUTIL dbanalys or tabanalys utility. The information appears in the RECORD BLOCK SUMMARY section.
RECORD BLOCK SUMMARY FOR AREA "Cust_Data" : 9
-----------------------------Record Size (B)-----Fragments--Scatter
Table Records Size Min Max Mean Count Factor Factor
PUB.Customer 1247 3.9M 98 30118 3259 2200 1.0 1.0