I would start by analyzing the queries to determine which columns are used most frequently in WHERE clauses and JOIN conditions. Based on this analysis, I would create appropriate indexes on these columns, particularly covering indexes if multiple columns are involved, to speed up range queries while being mindful of write performance and maintenance costs associated with these indexes.