Skip to Content
Mar 08, 2017 at 02:46 PM

SAP HANA Execution Plans - Actual vs. Estimated


What would be the easiest way to compare an Actual Execution Plan with an Estimated Execution Plan?

I can of course call "Visualize Plan" twice, once for Prepare and once for Execute but this is quite combersome.
In the end I need to compare the estimated number of rows to the actual number of rows to see where the optimizer fails to deliver appropriate estimates.

Next step would be to create/update statistics for the involved tables/columns.
How would I create a statistic which works on a simple predicate like "[ProductID] = 1" and ensures the correct estimate is provided to the query optimizer?

thanks in advance,