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.
| Version | Enterprise | Standard | Web | Express (Adv.) | Express |
|---|---|---|---|---|---|
| Version v2019 | Yes | Yes | Yes | ||
| Version v2017 | Yes | Yes | Yes | ||
| Version v2016 | Yes | Yes | Yes | ||
| Version v2014 | |||||
| Version v2012 |
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
Back to all features