Install the Query Hint Recommendation tool (Preview)

The Query Hint Recommendation tool allows you to identify an appropriate query hint to improve the performance of your query, directly from the query editor in SQL Server Management Studio (SSMS).

Prerequisites

To use the Query Hint Recommendation tool in SSMS, you need:

• SQL Server Management Studio (SSMS)

Install the Query Hint Recommendation tool using the Visual Studio Installer

1. Launch the Visual Studio Installer.
2. Select the installation of SSMS you want to modify, then select Modify.
3. Select Code Tools on the Workloads tab. Query Hint Recommendation Tool (Preview) appears as a selected component beneath Installation details.
4. Select Modify to install the extension.

Uninstall the Query Hint Recommendation Tool using the Visual Studio Installer

You can remove the Query Hint Recommendation tool from your SSMS installation using the Visual Studio Installer.

1. Launch the Visual Studio Installer.
2. Select the installation of SSMS from you want to remove Query Hint Recommendation tool in SSMS, then select Modify.
3. Select Code Tools on the Workloads tab.
4. Uncheck Query Hint Recommendation Tool beneath Installation details.
5. Select Modify to uninstall the extension.

Related content

• Use the Query Hint Recommendation tool (Preview)