Hi

I don't think a view will help much. It still has to execute the query to get the results.

If the results of count(*) do not have to be 100% accurate 100% of the time, why not analyze your tables (daily, weekly, or whatever interval is needed) and then select the results from ALL_TABLES?

-John