During automodify we create a temporary table for each round, populate it, query against it joining on projectid, and then delete it. This creates the table with an index so the join doesn't have to do a table scan for every evaluation.
Can confirm this works by comparing the automodify log output in the sandbox to that on TEST as there should be no functional change.
During automodify we create a temporary table for each round, populate it, query against it joining on
projectid
, and then delete it. This creates the table with an index so the join doesn't have to do a table scan for every evaluation.Can confirm this works by comparing the automodify log output in the sandbox to that on TEST as there should be no functional change.