Features

Plan guides and plan freezing for plan guides in SQL Server

Plan guides let you optimize the performance of queries when you cannot or do not want to directly change the text of the actual query in SQL Server. Plan guides influence the optimization of queries by attaching query hints or a fixed query plan to them. Plan guides can be useful when a small subset of queries in a database application provided by a third-party vendor are not performing as expected. GeoPITS brings you the comprehensive details of Plan guides and plan freezing for plan guides's support in different versions & editions of SQL Server.

Explore Plan guides and plan freezing for plan guides In Different SQL server Versions & Editions

VersionEnterpriseStandardWebExpress (Adv.)Express
Version v2019 Yes Yes Yes
Version v2017 Yes Yes Yes
Version v2016 Yes Yes Yes
Version v2014
Version v2012

Frequently Asked Questions

Plan guides let you optimize the performance of queries when you cannot or do not want to directly change the text of the actual query in SQL Server. Plan guides influence the optimization of queries by attaching query hints or a fixed query plan to them. Plan guides can be useful when a small subset of queries in a database application provided by a third-party vendor are not performing as expected

You can find more details about this version here

We run all kinds of Database services that vow your success