Hi Everyone,
I am considering ways to increase the performance of my application, and currently, because I need to record counts of a few tables in the Oracle db, would anyone think that it's beneficial to create a VIEW table that contains (at least) two fields: (tableName, recCount), containing the tableName, and the recCounts of that specified table?

Eg) SELECT COUNT(*) FROM EMP; -> 230921 records

View Table: V_TABLERECS
TABLENAME
-------------
'EMP'

RECCOUNT
--------------
230921

I hope I was clear in my question...

Please advise..

Thanks.

Frank