How to check on the status of a table indexing request

Curiously Cory
Kilo Expert

Is there a way to check on the status of a table indexing request? I made the change 6 hours ago and it's still not complete. 

1 ACCEPTED SOLUTION

Curiously Cory
Kilo Expert

I found the solution thank you to Simon Pullen who responded to my support request. You can find these indexing changes on the sys_schema_change table (nav to sys_schema_change.list). 

View solution in original post

5 REPLIES 5

pawan k singh
Tera Guru

Two steps to follow as given:

Step1 : Navigate to List view of the Schema table "sys_schema_change" or replace your Instance Name here

https://YOURINSTANCENAME.service-now.com/nav_to.do?uri=sys_schema_change_list.do

Step2: In Table Name Column, enter the table for which Indexes are applied and in "Alter Type" column filter by "Create Index(es)" as below. Short by "Updated" date to see when was the last Index created.

Example: For Incident indexes select Table Name = Index & Alter Type = Create Index(es)

At last, Please mark my answer helpful, if it helped.

find_real_file.png

Regards

Pawan K Singh