SAP-BI@Indices or Index of the Info Cube

Indices or Index of the Info Cube:-
-----------------------------------
2 types of Indices:-
--------------------
1) Primary Index
2) Secondary Index
 2.a. Bitmap Index
 2.b. B-Tree Index
2.a. Bitmap Index:-
* When the caridinality of Dimension table is less than the 20% of the Fact table.
2.b. B-Tree Index:-
* When the caridinality of Dimension table is more than the 20% of the Fact table.
NOTE : RSDEW_INFOCUBE_DESIGNS  - will give the cardinality of the dimension tables.
* Card Height ( check box )
Note :- When we Build indices on a Info Cube it improves Query Performance but it Degrades Loading Performance subject to Data Volume.