Laravel Query Optimization with Indexes

Optimize with indexes:

Add Index in Migration

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

Foreign Key Index

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

Drop Index

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

Explain Query

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

Best Practices

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