Index Optimization

Review and modify your database indexes to ensure they align with query patterns. Remove unnecessary indexes and add missing ones to improve query performance.

-- Remove unnecessary indexes
DROP INDEX index_name ON your_table;

-- Add composite index
CREATE INDEX composite_index ON your_table(column1, column2);