What is the impact of setting up Database Indexing on the sys_updated column for tables

[tweis]

I am getting this error when setting up snowmirror on many of the tables and wanted to know if the initial setup of indexing on the sys_updated column can cause any negative impact on our performance for our instance? I am sure that once the index is set up it should improve performance but not sure about initially.  

[Aditya Telideva]

Hi Troy,

The below article could help you understand the impat:

Improve performance: database indexes and slow queries

Thanks,

aditya Telidevara

[shruti_tyagi · Accepted solution]

Hi Troy,

Yes database index is supposed to improve query performance, so you need to see why you are adding DB index and if it is required. Bad index can have performance impact on query.

But in your case you are trying to add single index on sys_updated field, I would say this will either improve the query performance or will not have any impact. In order to make sure and test your query is slow and to see the explain plan check out this documentation:

make sure your query is slow:

https://docs.servicenow.com/bundle/jakarta-servicenow-platform/page/administer/platform-performance/...      

Generate index suggestions:

Generate an index suggestion for a slow query

Thanks

Shruti

If the reply was informational, please like, mark as helpful or mark as correct!