Index maintenance after large deletion
Hello,
I deleted around 30 % from notification table reducing its size from 300 mln rows to 200 mln. I have on this table PK and 3 non-unique indexes. During non peak time there are around 50 - 100k inserts within one hour.
Do I need to trigger any index maintenance (eg. recreate primary key constraint) and if yes would be safe to run it during non peak hours ?
thanks in advance,