Slowness in deleting CSM Household membersIssue Slowness in deleting CSM Household membersSymptomsYou should see something similar to the following in the logs: WARNING *** Large Table: Table handling an extremely large result set:Query that got us here is: TABLENAME = csm_household_member ENCODED_QUERY = consumer=^household=^start_dateISEMPTY^ORstart_date<=javascript:gs.daysAgoStart(0)^end_dateISEMPTY^ORend_date>=javascript:gs.daysAgoStart(0) ReleaseAnyCausecsm_household_member table has null values on consumer and household fieldsResolution Make sure that the data values in [csm_household_member] table and consumer and household fields are populated and other OOB mandatory fields in this table. The script in the business rule "Clear household field on case" is written with respect to OOTB functionality i.e. non empty consumer and household in the table. Please note that OOTB consumer and household fields in the table are mandatory because its a JOIN table between consumer and household entities.