Datawarehouse Database Best practices
We see lots of performance issues on huge tables especially during Informatica ETL loads on those huge tables. I also observed that those tables stats are NOT gathered every day inspite of scheduled gather stats program.
Please provide the common best practices on monitoring, maintenane and performance troubleshooting on Dataware house Database.