Rob, October 21, 2016 - 3:34 pm UTC
Helpful so far!
Rob, October 21, 2016 - 3:36 pm UTC
Rob, October 21, 2016 - 3:56 pm UTC
Yes, we define three foreign keys that use cascading delete on two tables. Should an index be defined on all three of these columns?
October 21, 2016 - 3:59 pm UTC
Yes. You need indexes on all the columns pointing to the parent you're deleting from.