Sets the maximum number of threads per single-user connection, when multi-threaded optimization is applied. Used when processing queries, and in batch feeder and cube load operations.
Parameter type: optional, dynamic
Default value: -1
To specify a maximum number of threads for the multi-threaded optimization, add the following line to the Planning Analytics database configuration:
where n represents the number of threads to be used for a single operation.
If you set MTQ equal to a negative number, that is, MTQ=-N, the number of
threads that will be used is defined by the following equation:
T=M-N+1, where T=
the number of threads to be used by the system and M= the number of threads on the server.
For example, if your database has 64 cores and you set MTQ=-10, the system will use 55 threads.
By default, MTQ=-1, which sets the value to the maximum number of threads available to a database. The result is a dynamic system setting that consumes all threads.
If you set MTQ=1 or MTQ=0, multi-threaded optimization is turned off.
For more information, see "Improving processing performance with Multi-threaded Queries" in TM1® Operations.