Adding Indexes to Large Tables in Laravel Without Locking Them
Online index builds let you add an index to a 40-million-row table without freezing writes, but only if you ask the database for them explicitly and guard against the locks...
Dasun Kalupahana
6 min read