Skip to Content

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,
-gerhard

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers