MariaDB Indexing Notes For Small Laravel Apps

Indexes should follow real query paths.

For content sites, slugs, publication flags, and publication dates usually matter before complex search infrastructure. Admin workflows often add their own sorting and filtering needs, so those paths should be checked too.

The goal is not to index every column. The goal is to make the routes and review screens people actually use stay predictable as content grows.