#sqlhelp is there an easier way to determine if a query plan is trivial, other than shredding the plan xml? Query Store isn't an option unfortunately. Thanks.
2
0
0
585
0
@sql_r There's a check for that in BlitzCache, if you want to make life a little easier: github.com/BrentOzarULTD/…
@sql_r If all you want to do is to see if it's specifically trivial couldn't you just do a pattern match on the XML? It won't be super fast but faster than shredding the XML properly.