Recently I've been struggling with custom table deactivation proccess. I need to deactivate a bunch of tables it's associated fields, and one thing that got me stuck in the proccess is: what's going to happen with the associated database indexes those tables have?
There's scarse information regarding this topic. And all of the information I could find states that database index and text indexes should not be deleted, or should be performed by Hi-Support.
My question is: What's going to happen with all those database indexes once all the tables are deactivated. Will this have an impact on the instance performance?
If the tables are deactivated, the indexes would not be utilized. Thus they have no impact on instance performance. They would still occupy some space in the instance, but typically that is a fraction of the space taken by the table itself.
If the tables are deactivated, the indexes would not be utilized. Thus they have no impact on instance performance. They would still occupy some space in the instance, but typically that is a fraction of the space taken by the table itself.
