You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Previously, we have the session variable tidb_opt_insubq_to_join_and_agg to control the in subquery's behavior. But the variable is not very suitable for SPM.
And that variable only controls the IN subquery. It doesn't handle the EXISTS because we need to decorrelated first then check whether we can rewrite the semi join.
This time, we introduce the hint to control its behavior.
The text was updated successfully, but these errors were encountered:
Enhancement
Previously, we have the session variable
tidb_opt_insubq_to_join_and_agg
to control the in subquery's behavior. But the variable is not very suitable for SPM.And that variable only controls the IN subquery. It doesn't handle the EXISTS because we need to decorrelated first then check whether we can rewrite the semi join.
This time, we introduce the hint to control its behavior.
The text was updated successfully, but these errors were encountered: