Originally posted by Mnemonical
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?

Rebild Index is not required...Though Drop Index during bulk load and recreate them wud be good choice...

Analyze - Might be (Not sure) if it really helps in improving performance.

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