Indexes SAP bw InfoCube

Indexes:pointer to the records-----olap processor can serache record easily---db read time reduced

there r 2 types of indexes---bitmap//btree indexes/////primary indexs--maintained  by sys///secondery indexes--user

btree indexes r created on cardinality high table///bit map indexs r created on cardinality low table

table----Records


emp dim table
100
200
100
300
200----------------more repated values----cardinality low---

sales oredr dim
order no---1/2/3/4/5/'6---cardinality high


Note:indexes on info cube improves query performance but it tampers ur loading performance

before data loading delet indexes and after data loading maintain indexs--

to verify the indexs----se14---fact table