BW 7.4 on HANA and DSO (Classic Standard) Secondary index

[Former Member]

Hi,

We are on BW 7.4 on HANA and using Standard DSO's (Not ADSO).

We have lookup's in the transformation with select statements on DSO's.Questions is is Secondory index on DSO still relevant to imporve data load performance in BW 7.4 on HANA.

Thanks

[FCI · Accepted solution]

Secondary indexes are not needed anymore on a Hana table (because of the columnar storage).

Note that in the Hana migration operations, all the (non-unique) secondary indexes are deleted.

Regards,

Frederic

[Former Member]

Thanks for clarification.