Yesterday our loading software came to a halt in the production environment. The DBA team came to the rescue and determined some tables had indexes that were just out of date. A quick real time rebuild got things rolling again.Now our DBA team is looking to be more proactive. We had a weekly job that rebuilds the indexes for some major tables. However we started looking for other tables to rebuild indexes for.
The DBAs told us that they were looking for tables that were frequently updated. I found one such example. A DBA chimed in and agreed the table I identified was a trouble table from a prior performance issue.
You would think that Oracle would have some built in support to keep indexes up to date.
