cancel
Showing results for 
Search instead for 
Did you mean: 

Update Statistics and Rebuild of Indexes

Former Member
0 Kudos

Hi friends,

If I execute the Update statistics for a given table thru DB20 does it have any effect on the indexes of this table or is it necessary to rebuild the index using db02

Regards

Aliila

Accepted Solutions (1)

Accepted Solutions (1)

former_member204746
Active Contributor
0 Kudos

DB20 does not rebuild indexes, it only recalculates statistics.

Former Member
0 Kudos

Hi Eric

Thanks for the confirmation on my doubt

Regards

Aliila

Answers (1)

Answers (1)

Former Member
0 Kudos

Updating Statistics does not rebuild index while in update states logs it will show you information regarding which indexes needs to be rebuiled which you can rebuild by brtools or executing rsanaora prg in se38.

Shivam