Oracle views vs. materialized views

• Materialized views are disk based and updated periodically base upon the query definition.

• Views are virtual only and run the query definition each time they are accessed.

Count rows in partition

SELECT table_name,
partition_name,
high_value,
num_rows
FROM all_tab_partitions
ORDER BY table_name, partition_name;