Thursday, September 02, 2010

What are plan guides?

Just a while ago I was watching a video on sqlshare Creating a Plan Guide for a Parameterized Statement By Andy Warren . Only then I heard about plan guides. I didn't know what plan guides were. Here is my find from googling


In SQL Server 2005, there is a new feature called Plan Guides that can help out in some cases where you discover poorly performing queries that you don't have direct control over. Essentially, a Plan Guide allows you to add or modify query hints to queries on the fly, just before they are executed. Click here for a detailed article on plan guides by Brad McGehee.

No comments:

How to download files from Microsoft Fabric Lakehouse ?

  Challenge : Yesterday I was trying to download a parquet file from the Microsoft Lakehouse on to my laptop.  So I was searching for the do...