Skip to Content
0
Nov 08, 2022 at 09:37 AM

Fields Join on Hana

189 Views Last edit Nov 08, 2022 at 11:16 AM 2 rev

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