What is Laravel database query optimization using indexing strategies?

Query optimization uses indexing, query planning, and selective data retrieval to improve performance.

Database indexing improves query speed by reducing full table scans. Laravel supports defining indexes in migrations. Composite indexes help optimize multi-column queries. However, over-indexing slows down inserts and updates. Query optimization also includes selecting only required columns, avoiding N+1 queries, and using eager loading.