Can I read SAP BW Indexing Overview by Mukherjee on EtoBox?

SAP BW Indexing Overview by Mukherjee by Benjamin Friedrich is a document available to read on EtoBox.

What is SAP BW Indexing Overview by Mukherjee about?

The document discusses the indexing scheme used in SAP BW. Standard InfoCubes use a non-unique primary index on all dimension IDs. Each dimension key column is bitmap indexed, except for line-item dimensions which use a non-unique B-tree index. Real-time InfoCubes also use bitmap indexes but replace them with B-tree indexes for the F fact table to allow for concurrent writes. Dimension tables have a non-unique primary B-tree index on the dimension ID.

Author

Benjamin Friedrich

Language

EN