Great video, and very relevant. Been using this "trick" many times, and looking forward to when the optimizer will actually be able to sort it out if the required indexes do exist
I've only ever found it useful for long stored procedures. In recent years it has not kept up with SSMS in exposing various query plan details. Solar Winds has really dropped the ball on it. The last couple versions won't even open up on my computer, they just crash instantly.
@@ErikDarlingDatait's an absolute tragedy. The biggest problem I have it is crashing whenever the memory grant feedback kicks in. I wish they would open source it, I use it often enough that I would happily contribute.
Yep - I get why they keep it and why they don’t care. It probably generates email leads and doesn’t make any money. It would probably be more valuable on both fronts if it were open source.
Great video, and very relevant. Been using this "trick" many times, and looking forward to when the optimizer will actually be able to sort it out if the required indexes do exist
It can often figure that out, but the better plans get costed out of consideration. It’s a real shame.
Awesome video! Thanks very much!
I think I saw 10 or so OR statements in our stored procedures.
well now there's 11
Why don't you use SQL Sentry Plan Explorer for examining your execution plans? I think it is more clear than the built in tool in ssms
I've only ever found it useful for long stored procedures. In recent years it has not kept up with SSMS in exposing various query plan details. Solar Winds has really dropped the ball on it. The last couple versions won't even open up on my computer, they just crash instantly.
@@ErikDarlingDatait's an absolute tragedy. The biggest problem I have it is crashing whenever the memory grant feedback kicks in. I wish they would open source it, I use it often enough that I would happily contribute.
Yep - I get why they keep it and why they don’t care. It probably generates email leads and doesn’t make any money. It would probably be more valuable on both fronts if it were open source.
13:07 This feels like one big jab at sp_BlitzIndex's mode 3.
Hahaha, no, just the people who copy and paste from it without any due diligence.
Would the expanded query with the union all be good to keep instead of the or, or are there performance implications?
I'd generally opt for the union all query for a number of reasons.
@ErikDarlingData thanks!
Not sure if I could think of UNION ALL in that situation but regardless, thanks for the tip. Hope I'll use it sometime
Once you get going with it, it gets easier and more intuitive.