Have partitions and subpartition to defragment
We have a huge list of table partitions and subpartitions planned for fragmentation but the problem is time for each subpartition takes time and using online option it also go for rebuilding /colaeasing same set of indexes each time.
Is there a way to avoid the circle of index rebuilds for same same table