Skip to Content
avatar image
Former Member

What happened to PlanViz

Curious if anyone - particularly from SAP, like Lars Breddemann - is familiar with the new PlanViz operators in HANA 2.0 onwards?

Most of my recent projects have been on HANA 1.12, but when recently prototyping something on HANA Express Edition - I found a completely different set of operators when trying to run PlanViz on a simple star join Calc View.

Here is some test SQL, a screenshot of the operators I came across, and system details for what I'm running this on.

CREATE COLUMN TABLE Z(F INT); 
INSERT INTO Z VALUES(1); 
-- Run PlanViz on following query
SELECT SUM(F) FROM Z;

operators.png (16.3 kB)
system-deets.png (42.1 kB)
system-deets.png (42.1 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Oct 25, 2017 at 04:46 AM

    Hi Jody

    good work on posting this question including all relevant information from the get-go.

    If there would be a >>everyone look here - this is how it should look like<< option, I'd use it for this question :)

    To provide an answer: with HANA 2 a new query plan generation and execution framework has been introduced to HANA (HEX - HANA EXECUTION ENGINE). The goal for this is to enable the overarching query planning and optimisation across the different execution engines (and several other important features).

    Since this change in HANA is not part of the outbound functionality (i.e. correct queries should continue to execute successfully regardless HEX usage or not), it is not covered in the documentation on HANA functionality (at least, that's my understanding for the reason behind this).

    Beyond that, I would not expect to see the HEX plans to be used for all queries immediately, but rather a progression towards the new engine for more and more scenarios.

    Hope, it helps a bit to know that PlanViz is not broken :-)

    Cheers,

    Lars

    Add comment
    10|10000 characters needed characters exceeded

  • Sep 06 at 06:49 PM

    Hi,

    Not directly related, but after switching from 1.0 to 2.0, is there any list of "new" parameters to setup? I am not Basis guy so .... :)

    Regards,

    Dominik

    Add comment
    10|10000 characters needed characters exceeded