How to use live aggregated projection ?
I have situation where I need to use aggregated query within a sub query.
sum(a.col2) as col2,
sum(a.col3) as col3,
sum(nvl(col3,0)) as col4
col4 between to_date('09/01/2016', 'MM/dd/yyyy') AND to_date('08/31/2018', 'MM/dd/yyyy')
join table2 b on x.col1 = b.col1
Here in this query, inner sub-query is taking to long time. So I try to use live aggregated projection. After creating a projection like:
CREATE PROJECTION table1_lap AS
GROUP BY col1;
But execution time did not reduce. Please tell me the solution.