L lappup New Member Feb 7, 2005 #1 Is there a system table that hold record counts? We are tying to find the number of records we have in each table. Due to its size, a sequential scan is out of the question - any ideas?
Is there a system table that hold record counts? We are tying to find the number of records we have in each table. Due to its size, a sequential scan is out of the question - any ideas?
M methyl Member Feb 7, 2005 #2 The external way would be to use proutil. Ours takes 20 mins to analyse 100 million records in a 27 Gb database. e.g. proutil -C tabanalys -db database_name.db > myanalysis.lst
The external way would be to use proutil. Ours takes 20 mins to analyse 100 million records in a 27 Gb database. e.g. proutil -C tabanalys -db database_name.db > myanalysis.lst
