You can use "help database databasename;"
Select * from dbc.tables where databasename = 'databasename';
Select 'Select count(*) from trim(databasename)||'.'||trim(tablename)||';'
from dbc.tables where databasename = 'databasename';
then execute the results.
dbc.tablesizev for tablesize.
is there any dbc object to find the actual count of each table ?
Are your statistics up-to-date ?
srik16, May i know your client DBMS version?