What is the database index ?

[Roshini]

What is database index? And how is it different from unique field in the dictionary entry.

What happens if we set a field to database index?

What is the behaviour of a field that is the database indexes records ?

[Ravi Chandra_K · Accepted solution]

Hello @Roshini  

Greetings!

There must be Unique values for the unique field (or there shall not be duplicates already to create unique field). It's like telling the system to only allow unique values for that field.

Data base index is a sql index where only the fields that will be looked up often must be indexed. refer the below thread:

https://www.servicenow.com/community/now-platform-forum/what-is-text-index-and-database-index-purpos...

https://www.servicenow.com/community/now-platform-forum/how-does-a-table-index-work/m-p/1063598

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

Please mark the answer as correct solution and helpful if helped.

Kind Regards,

Ravi Chanda