Missing Index Candidate (ARCH7058)

Key php.orm.missing-index-candidate · Severity info · Category orm

When a column is repeatedly used in filter/order/lookup predicates but has no index declaration, queries fall back to full table scans. Such columns are candidates for a DB index.

Incorrect

<?php
// 'email' is filtered often but has no index in the migration
Schema::create('users', function ($table) {
    $table->id();
    $table->string('email');
});

Correct

<?php
Schema::create('users', function ($table) {
    $table->id();
    $table->string('email')->index(); // index the frequently-filtered column
});

Fix

Add an appropriate database index to frequently filtered/sorted columns.