I’m working on SQL queries for business intelligence analytics reports, but some queries are too slow when processing millions of rows.

What I’ve Tried:

Added indexes but only saw minor performance improvements. Used EXPLAIN ANALYZE to check query execution plans. Tried materialized views, but they take too long to refresh.