Re: Tuning large aggregation query

From: Thomas Kellerer <>
Date: Mon, 07 Apr 2014 08:09:41 +0200
Message-ID: <>


thanks for the answer.

> I assume the FK of sales_data points to PK of base_table?
> If this is correct you can try to aggregate "just" sales_data:

Unfortunately that is not possible because some of the aggregations are done conditionally using e.g. sum(case when ... end) based on information in the base_data table.


Received on Mon Apr 07 2014 - 08:09:41 CEST

Original text of this message