Skip to Content
1

SAP HANA Execution Plans - Actual vs. Estimated

Mar 08, 2017 at 02:46 PM

69

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers