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
Vitess currently handles straight joins exactly like joins. This isn't exactly correct because STRAIGHT_JOIN makes MySQL not reorder the join tables -
STRAIGHT_JOIN is similar to JOIN, except that the left table is always read before the right table. This can be used for those (few) cases for which the join optimizer processes the tables in a suboptimal order.
It will be great if Vitess does the same, wherein we respect straight joins and don't reorder the tables.
Use Case(s)
This gives more control to the users in the plan that Vitess creates for join queries.
The text was updated successfully, but these errors were encountered:
Feature Description
Vitess currently handles straight joins exactly like joins. This isn't exactly correct because
STRAIGHT_JOIN
makes MySQL not reorder the join tables -It will be great if Vitess does the same, wherein we respect straight joins and don't reorder the tables.
Use Case(s)
This gives more control to the users in the plan that Vitess creates for join queries.
The text was updated successfully, but these errors were encountered: