Skip to Content
Jan 16, 2017 at 04:59 PM

Star Joins in today's HANA



I've asked this question a long while ago but did not get a satisfactory response.

So.. here goes another try..

As we know, there is a star join option while creating a calculation view graphically.

I've been hearing from certain people that creating a view using the star join is better for performance.

I've never found evidence to support this but would like a healthy discussion on the below questions:

1. Does it indeed offer any performance benefits?

2. If yes, under what scenarios would it be used ? I've lived perfectly fine not using them but are there special cases when they perform better? If yes, an example scenario might be great for my understanding.

Thanks in advance.

Shyam Uthaman