the cascades xformed opeartor should derive their stats own #58905
Description
Enhancement
ref: #51664
from the pic above, we could see that, the transformed join(physicalized as index join) converted from apply-rule in cascades, didn't show the correct est rows with the same plan generated from normal planner mode.
the reason is that: currently the new generated/xformed logical operator will inherit their source operator's stats(row count included), so even the new join has its own stats derive logic, it couldn't derive it's own stats again because the reuse mechanism.