You are tasked with improving the performance of a reporting database that stores historical sales data. The reports involve complex aggregations and filtering. How would you use indexing to optimize the data retrieval speed for such reports?

Composite indexes, involving multiple columns, can efficiently handle queries with complex filtering conditions or involving joins. By storing the relevant columns together in the index, it reduces the need for accessing the main table, thereby improving query performance.