3 ms·
> I've seen scheduled index rebuilds on Oracle If you do look into the Oracle dba handbook, scheduled index rebuilds are somewhat recommended. We do it on week
by braggerxyz 2y ago
> I've seen scheduled index rebuilds on Oracle
If you do look into the Oracle dba handbook, scheduled index rebuilds are somewhat recommended. We do it on weekends on our Oracle instances. Otherwise you will encounter severe performance degredation in tables where data is inserted and deleted at high throughput thus leading to fragmented indexes. And since Oracle 12g with ONLINE REBUILD this is no problem anymore even at peak hours.