cancel
Showing results for 
Search instead for 
Did you mean: 

Delete and create index step in BW 7.3

Former Member
0 Kudos

Hi Experts,

Please could you let me know why we don't have delete and create index step in PC for BW 7.3 which we generally do before and after cube load. We are using HANA as DB.

Accepted Solutions (0)

Answers (4)

Answers (4)

FCI
Active Contributor

Because index are not needed anymore on a Hana DB (because of its columnar storage).

0 Kudos

SAP BW 7.3 still have create and delete index step but not in the case of DB is HANA associated.

FCI
Active Contributor
0 Kudos

I can't check on the database itself at the time, but there seems to be only one (non unique) key according to the DDIC definition of the table.

There is only the DIMID of the package dimension as a key, the SID of the remaining characteristics of the cubes are just fields:

Regards,

Frederic

Former Member
0 Kudos

Thanks Frederic for your answer. Please could you tell me what primary keys it's going to consider in HANA db while creating columnar table for Infocube?