Question

Where clause in LAP

+1

hi,

I have to create Live Aggregate projection for a table which has 100Billion records.

I see we are not allowed to include where clause in the projection definition. Is there a way I can filter out data before aggregating them?

The anchor table has 30-40% of data which I dont to participate in the aggregation.

+1

Otherwise, a LAP is generally very small. It might take a bit to create it, but once built, shouldn't eat up a ton of resources.

Sign up