About indexes in cube

[Former Member]

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

[roland_szajko · Accepted solution]

Hi Sachin

Indexes are created for both Fact and Dimension tables. For the fact tables each key field (dimension) a separate index is created and there is also a so called surrogate index (has the name 900 if i remember correctly).

For dimension tables the indexes are created for each field.

This post contains also some useful information about the indexing under Oracle:

br

Roland

[former_member186586]

maybe helpful ?