Hi,
I would like to have some advice on optimizing join performance on Hana 2.0.
1)Suppose that
i have an integer field and a varchar field.
Does the join on an integer perform better in Hana than the join on the varchar field?
2) Suppose I have an integer key field and a varchar field (the varchar field also defines only a row even if not defined as a key)
does the join on the key field improve performance a lot compared to a join made on the varchar?
Thank you