How do you perform schema changes on tables with billions of rows in production without causing downtime or significant performance degradation? Describe the tools and techniques you use.

Sample answer preview

Schema changes on billion-row tables in production are among the most challenging operations a DBA performs. A naive ALTER TABLE on a table with billions of rows can lock the table for hours, block all queries, and effectively cause a complete application outage.