cancel
Showing results for 
Search instead for 
Did you mean: 

Question about index

Former Member
0 Kudos

Hi,

My question is under what kind of situation you don't need delete index before the ETL ?

Thanks a lot

Ryan

Accepted Solutions (1)

Accepted Solutions (1)

udayabhanupattabhiram_cha
Active Contributor
0 Kudos

Hi,

If the number of records that are currently loaded are very less than the number of records that are already in the Cube.

E.g., cube had 500,000 records.

THe delta load has 50 records.

In this case, I will not delete indexes.

Rather, drop and recreate all indexes week-end or before month-end loads.

Ram C.

Answers (4)

Answers (4)

udayabhanupattabhiram_cha
Active Contributor
0 Kudos

Hi:

I disagree with the posts that state that you should always delete indexes for Cubes before loads.

Its a design decition and not a hard-and-fast rule.

i still stand by my earlier post of deleting and re-creating only when the new records are >= 25% of Fact Table entries.

But, you should rebuild them during holidays/downtime like SUndays.

Ram C.

Former Member
0 Kudos

Hi Ram,

I agree with you.

Ciao.

Riccardo.

Former Member
0 Kudos

Hi Ryan,

also when you have a huge amount of data already in cube it is better to delete and create again index one time per week and not for every upload.

Ciao.

Riccardo.

Former Member
0 Kudos

When loading to cubes it is recomended deactivate them, due that star schema contain a lot of tables that should be updated. It is unsual deactivate them when loading ODS

Former Member
0 Kudos

It is best practice to delete the indexes before loading .

Regards

Manga

Former Member
0 Kudos

If you don't have loding performance problem you cannot delete index.

If you load large volume of data it's better to deletee index before and rebuild it after.

Hope it helps.

Regards