Database Administration (MOSC)

MOSC Banner

Index maintenance after large deletion

edited Oct 14, 2019 10:01AM in Database Administration (MOSC) 9 commentsAnswered ✓

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,

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center