For a read-heavy application, I would focus on creating indexes on frequently queried columns, particularly those used in WHERE clauses, JOIN conditions, and ORDER BY statements. I would analyze query patterns using tools like the query execution plan to identify which indexes would provide the most benefit while considering the trade-offs of write performance and storage overhead.