Кто использует KR3 ?

[Vadik]

Цитата:

Сообщение от Logger

А вообще со стороны Microsoft это подставлялово - менять таким образом хинты и не давать инструкций как ими пользоваться.

"Задним числом" была обновлена статья в Knowledge Base (ссылка на Partnersource) - в оригинальном Readme из дистрибутива не было циферок для Hint flag

Цитата:

Increased SQL Query Performance
Query (Transact-SQL) hint removal flags have been implemented in Axapta 3.0 Kernel Rollup 1 to increase query performance for large datasets. With the hints removal implementation of query hints, users will have the ability to specify that Axapta database queries not use indexes or table join order. They will, however, be able to specify the strategy to use when joining. Previously these capabilities were enabled only within SQL Server. The following table lists the enabled hint removal flags.
Hint Query keyword Startup Command
Ltrim [LTRIM] 8192
Nestedloop [LOOP JOIN] 2048
selected order [FORCE ORDER] 1024
index [INDEX] 512
To implement the removal of the default hint flags in Axapta, simply add the Startup Command flag to the Startup Command field in the Navision Axapta Configuration Utility, General tab, and apply the changes to save the configuration. When a hint flag is disabled in SQL Server, the query generated by Axapta 3.0 Kernel Rollup 1 will remove the query keyword hint from the query. The following example demonstrates an enabled index hint and ltrim hint.
Example: SELECT A.ZIPCODE,A.RECID,A.RECVERSION FROM ZIPCODE A(INDEX(I_517ZIPCODEIDX) NOLOCK) WHERE (DATAAREAID=?) AND ({fn ifnull({fn LTRIM(ZIPCODE)},ZIPCODE)} LIKE ? ESCAPE '\' )) OPTION(FAST 100) [ID=70, Reused=No]The following example demonstrates a disabled ltrim 8192 with the Startup Command flag set.
Example: SQL Server statement: (ZipCodeTable)
SELECT A.ZIPCODE,A.RECID,A.RECVERSION FROM ZIPCODE A(INDEX(I_517ZIPCODEIDX)) WHERE ((DATAAREAID=?) AND (ZIPCODE LIKE ? ESCAPE '\' )) OPTION(FAST 100) [ID=28, Reused=No]

Так что можно сказать, что инструкции дадены