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
Currently, in the planner, the choice between push down TopN or not is cost-based. But sometimes the cost calculation is not accurate enough to make the correct choice. When we choose not to push down TopN when it should, the SQL execution will become very slow sometimes. Considering the risk and benefit, always choose to push down the TopN may be a better strategy.
The text was updated successfully, but these errors were encountered:
Enhancement
Currently, in the planner, the choice between push down TopN or not is cost-based. But sometimes the cost calculation is not accurate enough to make the correct choice. When we choose not to push down TopN when it should, the SQL execution will become very slow sometimes. Considering the risk and benefit, always choose to push down the TopN may be a better strategy.
The text was updated successfully, but these errors were encountered: