Like hint on join, sometimes we need hint on temporal table join. For example, specify USE_HASH hint on temporal table join like the following sql,
Now, above sql would translate into correlate instead of Join, like the following Tree Node.
However, correlate is not a hintable node now and the hint could not be propagated to the correlate nodes.
So I wonder could we extend correlate to be a hintable node?