I have a table of about 30 columns and 10 global unpartitioned indexes on it. The table is partitioned using Interval partitioning. Partitionig is done on a daily basis.
Data in the table is huge and is online(Insertions and extraction of data keeps on happening round the clock). I run a script on a daily baisis to delete 10 days old parition. After deletion the indexes becomes unusable, which approach should i follow to rebuild the indexes.