1. Let's suppose I truncate a table and insert 1 million rows (it had 1 million rows before truncating). Do I need to rebuild indexes and analyze the table?

2. How do I update a materialized view if it containts more than one table in from clause ?


Thanks

F.