To improve performance on a SQL Server database, users may wish to use the NOLOCK table hint to avoid applying exclusive locks to tables whilst executing queries. Is it possible to add a NOLOCK string for SQL generated within the Strategy Engine?
It is not currently possible to append the NOLOCK setting within Strategy. An enhancement request has been submitted for this functionality to be considered for implementation in a future version. Please contact Technical Support to request an update on the status of this issue.
Third Party Software Installation:
WARNING:
The third-party product(s) discussed in this technical note is manufactured by vendors independent of Strategy. Strategy makes no warranty, express, implied or otherwise, regarding this product, including its performance or reliability.
