|
![]() |
#1 |
Модератор
|
To gain immediate benefit from the new Literals feature, even when running X++ queries that has not yet been tuned for neither Literals nor Placeholders, Axapta will auto apply Literals on certain X++ join-constructions. That is, unless told otherwise, joins involving more than one table assumed large, will have Literals auto applied.
The kernel assumes that a table may be large, if it is included in the table groups: Miscellaneous, Main, Transaction, Worksheet Header, Worksheet Line. The kernel assumes a table is small, if it is included in the table groups: Parameter, Group So unless an X++ programmer has explicitly specified that a join query should use either Placeholders or Literals and the join references at least two of the ‘assumed’ large tables, above mechanism will be in effect! Как я понял, это учитывается, когда система решает, использовать ли уже прекомпилированный запрос с новыми параметрами или разбирать и выполнять его заново Надо будет на ночь Cost-based optimizer почитать ![]() |
|
|
Опции темы | Поиск в этой теме |
Опции просмотра | |
|