Re: Tuning large aggregation query
- From: Thomas Kellerer <thomas.kellerer@xxxxxxxxxx>
- To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 07 Apr 2014 08:09:41 +0200
Martin,
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.
Regards
Thomas
--
//www.freelists.org/webpage/oracle-l
Other related posts:
