Explain plan not giving correct details about join cardinality

[former_member679919]

Hi All,

I am facing an issue when running an explain plan for one of my calculation views in HANA Studio. Ideally, the Explain plan SQL,when run with cardinality HINT should give the details of the bid with join condition which is having incorrect cardinality. But it is not giving expected results. Can you please help on this ?

Here is the output i got when I ran the SELECT statement with cardinality HINT:

cardinalityerror.png

Here is the output of explain plan:

explainplanoutput.txt

[HakanHaslaman]

Is that the SAP Note, that you are following?
https://launchpad.support.sap.com/#/notes/2737941