Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

Database Indexes best practices?

SrrnAlejandro
Tera Contributor

Wednesday

Hi everyone!

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?

0 Helpfuls
  • 277 Views
2 REPLIES 2

Jeff Currier
ServiceNow Employee
ServiceNow Employee

Wednesday

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.

0 Helpfuls