off the top of my head, it looks like the join condition involves two columns, so there should be an index which includes both columns, although it’s not clear which should be the leading column
please let me know if you need an explanation for this
2 Likes