Execution Plan Analyzer is a feature that will cut your query troubleshooting time at least by half or more. With it you can
easily see the costliest plan operators based on different properties like IO, CPU, Number of rows, Cardinality, Relative cost, etc... Can't find a node that is on a particular index? Need that specific nested loops join? Not a problem anymore. With
plan searching this now as easy as pie. And just when you think things can't get better they are with
Execution Plan Auto Analyzer. It goes through your plan finding most common problems and gives you the usual solution for each one. This feature isn't meant to replace manual analysis but it will find the usual problematic spots that you can fix up fast.