Index fragmentation jobs ( rebuild or reorg of indexes) can take a long time, especially on the RT table. Does Broadcom have any best practices for speeding this up?
Release : Automic Workload Automation - all releases
Component : AUTOMATION ENGINE
A DBA is the best resource to talk to about index fragmentation on the database. Broadcom does not provide scripts to rebuild/reorg indexes as we do not have the in-depth knowledge needed for specific environments and tuning that a DBA familiar with those should have.
As index reorg/rebuild is the best way to resolve high fragmentation; there are some ways that a DBA may be able to suggest in keeping fragmentation down to begin with. Some best practices that may keep fragmentation down: