How to determine who and when was the database index created?

[miro2]

Hi,

In custom table configuration in Database Indexes related list indexes records were created automatically for reference fields (u_tags and u_user_id_json). Each time I refresh this updated and created field is changes to current data/time. 
Why it's working like that. I know I can create indexes by me self but for reference fields these were created automatically. 

In client instance update by/created by is says my user name, not system or admin but I didn't created them.

in sys_schema_change it's looks like this

[Vasantharajan N]

@miro2 - Table Schema change table provide the data when the index actually got created on the table. But the index is keep getting updated whenever the transaction (Insert/Update/Delete) happens on the table which you are seeing in the "Related list" is created when you open the table record(sys_db_object)

[miro2]

Hi @Vasantharajan N 
so for reference fields indexes are automatically created by ServiceNow, so I do not have to manually create indexes for reference fields, correct? I am just trying to understand what's behind this. If you could provide some reference documentation, that would be very helpful.

[Vasantharajan N]

@miro2 - Yes. Indexes are automatically created for the reference field(s) in the table.