That's sufficient information for me thanks! I don't really have a concrete
example at the moment. The idea just popped up in my head when I read that
CTEs are reused inside parent queries.
gg pw wrote:
> Do Aggregate functions/queries reuse the state value they generate for
> subsequent queries? If not then an explanation would be greatly appreciated.
The subsequent queries are not supposed to feed the same input into the
aggregates, so their aggregate states will most likely be
Do Aggregate functions/queries reuse the state value they generate for
subsequent queries? If not then an explanation would be greatly
appreciated.