Why is the table index creation time and created by being reported incorrectly?

[Nisar2]

Hi experts,

I wanted to check what indexes are defined on a table to see if I can improve query performance. Imagine my surprise when I clicked on "Configure->Table" from the list view and scrolled down to the "Database Indexes" tab and found my name listed against all the indexes when I didn't even create them.

Surprisingly, they all have a timestamp of "Just now". If I keep refreshing the list, it will keep saying "Just now".

This makes me believe that I'm looking at the wrong place. Even so, why does this list contain my username? What does this database indexes mean then?

[shloke04 · Accepted solution]

I have verified it in my instance and it is an OOB behavior looks like. System automatically creates few Database index against the table you have created and if it is extended from another table then you may see few additional database index created and it shows both Created and Updated as the current logged in user with current date time stamp.

Sam behavior is there for Plugins list as well , when you navigate to "v_plugin.LIST" to view the plugins installed, it shows both Created and Updated as logged in user name with current date time stamp.

Hope this helps. Please mark the answer as correct/helpful based on impact.

Regards,
Shloke

[shloke04]

Sure . Definitely 🙂

Just posting another article below which I found on Indexing and thought of sharing it as it contains helpful info

https://community.servicenow.com/community?id=community_article&sys_id=821a1d7c1b99d45017d162c4bd4bcbdf

Regards,

Shloke

[shloke04]

Have tried checking any script or anything which exist on Database index table but unfortunately don't see anything and looks like a platform behavior with lesser details exposed to us.

Regards,

Shloke