How to add Hints to SQL Server queries

Technique

Product: Reporting Server

Release: 8206

Primary OS: Windows

Solution Date: 2020-07-23

Problem

How to add Hints to SQL Server queries.

Solution

The SQL Server adapter allows you to add hints using the following command:

SQL SQLMSS SET HINT OPTION (hint_text)

The hint_text is the text of the hint or hints combination. The end user is responsible for the syntax. Omitting OPTION (hint_text) resets the hint to none.

The hint_text places the hints at the end of the generated query for Microsoft SQL Server.

This setting can be specified in any .fex or profile.

Information is published on an "as is" basis without a warranty of any kind. Information Builders, Inc. ("IBI") hereby represents that such information has not been subject to any formal testing or review by IBI. IBI assumes no responsibility for usage of such information, including the implementation of solutions associated therewith. The customer assumes responsibility for the results obtained from such information. IBI is not responsible for and shall not be held liable for the results obtained, including but not limited to any errors, delays or omissions. IBI disclaims any liability for the completeness or accuracy of such information.