Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

How can I avoid any degradation of index quality after many small deltas?

April 26, 2017avoid degradation Deltas index quality small

0

Posted

How can I avoid any degradation of index quality after many small deltas?

1 Answer

0

Posted

We recommend using the delta index for large database tables. Make sure that you regularly use RSRV to check the size of the delta index and to trigger the merge as a repair (alternatively, you can use report RSDDTREX_DELTAINDEX_MERGE). A customer can run this check as a regular BI Accelerator monitor check, which then displays any warnings in the monitor. For more information, see Improving Efficiency Using BI Accelerator Delta Indexes.