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.

Om Podcasten

Kendra Little's podcast discussing database performance tuning, software development, and working with data.