Why You Should Switch in Staging Tables Instead of Renaming Them

Performing a switcharoo between new and old tables can cause blocking nightmares. Partition switching may help, surprisingly even on non-partitioned tables.