restructuring reduces the number of table scans, improves perf on a moderate db by factor of 5 by addr_id and 4 by crmacct_id, and returns at least one record for each addr
Merge pull request #1915 from gilmoskowitz/i24381_addressViewPerformance

issue #24381 - restructuring reduces the number of table scans