By default, SQL Server queries generated by the NST will use the option "FAST x", e.g:

SELECT FROM WHERE ... OPTION(FAST 50)

Most of the time this is a good thing for performance. However, for some specialized high performance environments it can be a performance problem. Using "FAST x" can slow performance where:

(a) The application needs to process a large result set (e.g. many thousands of records) as fast as possible.

(b) There are multiple processors available for the SQL Server.

(c) The SQL Server "max degree of parallelism" configuration option is not set to 1.


Would it be possible to enable a configuration option for the NAV service tier so that partners can disable "FAST x" where they need to have the extra performance in this kind of environment?