Friday, August 31, 2012

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.

Thursday, August 23, 2012

Count rows in partition

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