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?
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…
#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.