Dynamics AX Sustained Engineering: Performance issue on Query Object when using Outer Join with more than one Child Table
Источник: 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
__________________
Расскажите о новых и интересных блогах по Microsoft Dynamics, напишите личное сообщение администратору.
|