Laravel Query Optimization with Indexes

$table->index('email');
$table->index(['user_id', 'created_at']);
$table->unique('slug');

$table->foreignId('user_id')->constrained()->index();

$table->dropIndex(['email']);
$table->dropUnique(['slug']);

User::where('email', $email)->explain();

- Index frequently queried columns
- Index foreign keys
- Use composite indexes for multi-column queries
- Avoid over-indexing