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

Nisar2 · ‎02-17-2022

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 · ‎02-18-2022

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

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

Regards,
Shloke

View solution in original post

Avro Guha · ‎05-25-2023

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.

View solution in original post

Hitoshi Ozawa · ‎02-18-2022

Can it be the table has a parent table? If so, the table will inherit indexes set on the parent table.

For example, if I set the parent table to be cmdb_ci, 103 indices will be created automatically.

Nisar2 · ‎02-18-2022

Yes, it exends a table. I understand that those indexes show up too. What I'm worried about is why does the list say that I created those indexes when it is 100% not the case.

Hitoshi Ozawa · ‎02-18-2022

Indexes are created when the table is created. "Created by" of the indexes will also be the person who created the table because they are created among with the table.

Nisar2 · ‎02-18-2022

I'm a little confused here. I did not create the table at all. More so, the timestamp keeps saying "Just now" if I keep refreshing that list view every 5 minutes.