No, there is no way to calculate time required for rebuilding indexes.
If the table has gone through a lot of DELETEs, rebuilding indexes will create some free space. But, its only temporary. If the table keeps on undergoing similar DML activity, the index will grow again.




Reply With Quote