Re: Query optimization or better table design?

[Rick James]

Shoveling thru millions of rows takes time. Period.

So, the 'right' way to deal with this 'report' on your 'data warehouse' is to create a summary table(s).

Every day (say), you run a script

INSERT INTO summary_table
SELECT day, domain_id,
       COUNT(*), SUM(...)
   FROM fact_table
   WHERE day ... # yesterday
   GROUP BY day, domain_id

Then run your report from that table. It will be plenty fast.