Hi,
I am trying to figure out how to use hints correctly.
My case:
I've registered hint for Aggregate node to force expand DISTINCT aggregate.
Because is some cases plan with DISTINCT aggregate to JOIN cannot be
chosen by the cost.
I see that different rules treat hints differently.
e.g.:
- AggregateExpandDistinctAggregatesRule - copy hints of the source node
for new aggregate nodes.
- AggregateReduceFunctionsRule - create new node and looses the original
hints.
Is is correct behavior and am I missing something at the hints/planner
logic?
--
Taras Ledkov
Mail-To: [email protected]
