Skip to Content
avatar image
Former Member

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

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Jan 16, 2017 at 12:53 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 16, 2017 at 04:04 PM

    Thanks for clarification.

    Add comment
    10|10000 characters needed characters exceeded