Query regarding index rebuilding
Oracle database version 12.1.0.2
1.On one of our production database we are facing database slowness issue.(there is excessive inserts, updates and deletes on a schema)
I am planning to rebuild a indexes for the schema on which excessive DML operations are performed.
I want to know if there are any risks with rebuilding indexes.
2.Also I have question regarding rebuilding partitioned and subpartitioned indexes.
-Do I need to rebuild partitioned indexes and subpartitioned indexes or simply rebuild indexes?
Any suggestions would be appreciated.
Thank you!