Okay; it's probably the foreign keys.  What indexes exist for the eight tables with foreign keys referencing the RetailMember table?  What DRI options (e.g. CASCADE DELETE) exist for those constraints?