• I'm not sure what {business_idx=$''STERILIZES''} does.

    The query looks fine if there are indexes on businessid, ZIPID.

    What does exec tdbExecuteReturnPageL @sql, 3, 20 ?