1.4 Lab 1: Get One Plan to Work Well Enough for Most

This morning, we’ve been looking at index tuning and query hints as ways to get one plan that works well enough for most people – not necessarily perfect for everyone, but just an acceptable number. Restore your Stack Overflow database to the starting point where you have the necessary indexes, then run the lab setup script at…

This morning, we’ve been looking at index tuning and query hints as ways to get one plan that works well enough for most people – not necessarily perfect for everyone, but just an acceptable number. Restore your Stack Overflow database to the starting point where you have the necessary indexes, then run the lab setup script at...