How much time it takes for Indexing a Field?

Chaisai
Kilo Expert

Hello, We have created a Transform map in which we have put Coalesce on the Asset table field "Serial Number", But whenever we are trying to index the field it is not getting done as we have tried multiple times, got a pop up like indexing has been scheduled but still not getting done. Also, it will be helpful like how much time it takes for getting Indexing done.

 

Thanks in advance!

7 REPLIES 7

Anurag Tripathi
Mega Patron
Mega Patron

Its difficult to put a number on it. It depends om the number of records on the table and the size of the database in all i think.

 

-Anurag

siva_
Giga Guru

It completely depends on the number of records in the table in my opinion

Alberto Consonn
ServiceNow Employee
ServiceNow Employee

Hi,

have a look to the Known Error below and the solution provided, it might be useful for fiy your issue:

Transform - Coalesce field not indexed

If I have answered your question, please mark my response as correct so that others with the same question in the future can find it quickly and that it gets removed from the Unanswered list.

Thank you

Cheers
Alberto

Thank you! We have tried already the mentioned way to index the field but still it is not getting done just getting a pop up showing indexing has been scheduled , so thinking this might be an upgrade issue ?