Dynamics AX 2012 R2 has been heavly normalized. Several key tables do not include the DATAAREAID field. For that reasen all records are loaded into TX if no DATAAREAID field is present. The TX optimization should take care of this if possible.
Optimize AX 2012R2 data source adapter to only include selected companies records