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
When planning a query that involves a join that looks like this:
select id, parent
from s, t
wheres.parent=t.id
assuming that we have a value index on t defined as id, parent, that index will not be used, although it might be appealing to do so, if the optimizer is capable of flipping the equality, i.e. t.id = s.parent.
The text was updated successfully, but these errors were encountered:
When planning a query that involves a join that looks like this:
assuming that we have a value index on
t
defined asid, parent
, that index will not be used, although it might be appealing to do so, if the optimizer is capable of flipping the equality, i.e.t.id = s.parent
.The text was updated successfully, but these errors were encountered: