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

[Avro Guha · Accepted solution]

Created By has nothing to do with who created Index. Its like history line, who ever opens the config page for the table it will show there ID as index created_by.

If you go to 'v_index_creator' you will not find any value. This table data gets entered when config for the table is opened and that's why it will show that person as created by. It indicates record created on the above table and not index created by. To my knowledge.

[shloke04]

Hi @Nisar 

The information you are looking for is given and explained clearly in the below HI article:

https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0752362

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

Regards,
Shloke

[Nisar2]

That does show you how to properly check for index historic data. However, my question still remains. When I'm looking at the "Database Indexes" related list, why does it show my name as creator?

[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

[Nisar2]

That's comforting to read. However, hope it's okay if I wait for a while to have this confirmed and then accept as answer.