1.6 Lab 2: Fixing Parameter Sniffing Problems with Branching

Now, it’s your turn: I’ll give you a query that is experiencing parameter sniffing problems, and some examples of different parameters that seem to trigger problems. Your mission is to implement branching (to reduce the blast radius. Restore your Stack Overflow database to the starting point where you have the necessary indexes, and then run…

Now, it’s your turn: I’ll give you a query that is experiencing parameter sniffing problems, and some examples of different parameters that seem to trigger problems. Your mission is to implement branching (to reduce the blast radius. Restore your Stack Overflow database to the starting point where you have the necessary indexes, and then run...
Menu