Forcing a Plan That Has a Plan Guide

The question that came up during a recent class I was teaching was: What if you have a plan guide to get the plan you want, but then decide, instead of using the plan guide, you’ll just force the plan?

Ummmm….

No idea. Let’s test it.

First, Create a Plan Guide

I have a couple of queries I use to teach about how statistics affects plan choice, so we’ll use that here. I’m going to also define and create a plan guide that makes this plan use a small row count for all queries against…

Read the entire article at the source link… Grant Fritchey

#codango #developer #development #coder #coding

We're happy to share this resource that we found. The content displayed on this page is property of it's original author and/or their organization.

 

Leave a Reply

Your email address will not be published. Required fields are marked *

*