LIKE cannot use an index and everyone knows it. The mapping, the analyzers that decide what matching means, the indexing pipeline, and the drift it introduces.
A single DELETE removing two million rows holds locks for the duration, generates one enormous transaction in the binary log, and a replica applying it single-threadedly falls behind…
WP_POST_REVISIONS is a constant, so it applies to the whole site. A catalogue whose products are updated by a nightly import does not want a revision per product…
Two services with their own repositories, deployments and teams still cannot change independently if they read the same tables. The dependency is real and invisible — nothing in…
A JSON column cannot be indexed directly, so a query filtering on something inside it scans the table. A generated column extracts the value into a real column…