Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

About indexes in cube

Hi BI Experts,

Do not mind if it is too basic question I'm asking.

I went through some docs and discussions and ended up with few queries.

I have read one doc where it was saying F fact table uses B Tree indexes and E fact table uses Bitmap indexes.

I also read in one of SCN discussions that indexes will be created on each column of dimension and it can be converted to B tree by enabling high cardinal.

Now, my question is, will index be created on Fact table or Dimension?

If it is on each column of dimension, which index technique will be used by default?

If possible, provide documents.

Can anyone please explain in detail? Guarantee in assigning points.

Thanks in advance.

Regards,

Sachin

Tags:
Former Member

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question