Re: Tuning large aggregation query

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  

--
http://www.freelists.org/webpage/oracle-l