Dynamics AX Sustained Engineering: Performance issue on Query Object when using Outer Join with more than one Child Table

[Blog bot]

Источник: http://blogs.technet.com/b/dynamicsa...ild-table.aspx
==============



Problem:
Sub-optimalSQL (multiple SQL statements) generated when a query object has more than one child table in the datasources nested directly under the parent table.

Resolution:
Changethe default "fetch mode" from “1:n” to “1:1” while linking the childdata sources to the parents.




Источник: http://blogs.technet.com/b/dynamicsa...ild-table.aspx