How does a table index work?

Anish Reghu
Kilo Sage
Kilo Sage

How does a table index work? Please cite an example to help understand.

 

Cheers,

Anish

1 ACCEPTED SOLUTION

Anshu_Anand_
Kilo Sage
Kilo Sage

Index is defined as to categorize or list, or to make adjustments automatically based on a particular changing statistic. An example of index is to put employees names in alphabetical order.

Indexing is one of the most important database features and must be implemented properly where needed to improve response time. Just like in other database-based applications, creating an index must be dealt with carefully, and only the fields that will be looked up often must be indexed. Indexing will not just improve the response time; it also greatly improves the database performance and can help optimize slow queries

A KB article explaining it in terns of servicenow

https://community.servicenow.com/community?id=community_article&sys_id=821a1d7c1b99d45017d162c4bd4bc...

 

A brief explanation of indexing with example. Indexing concept is common in any databases

 

If its helpful, please mark answer as correct

Regards,
Anshu

View solution in original post

2 REPLIES 2

Anshu_Anand_
Kilo Sage
Kilo Sage

Index is defined as to categorize or list, or to make adjustments automatically based on a particular changing statistic. An example of index is to put employees names in alphabetical order.

Indexing is one of the most important database features and must be implemented properly where needed to improve response time. Just like in other database-based applications, creating an index must be dealt with carefully, and only the fields that will be looked up often must be indexed. Indexing will not just improve the response time; it also greatly improves the database performance and can help optimize slow queries

A KB article explaining it in terns of servicenow

https://community.servicenow.com/community?id=community_article&sys_id=821a1d7c1b99d45017d162c4bd4bc...

 

A brief explanation of indexing with example. Indexing concept is common in any databases

 

If its helpful, please mark answer as correct

Regards,
Anshu

Omender Singh
Tera Guru

Following channel is very useful to get understanding of indexing. 

https://www.youtube.com/watch?v=50aPIttq25Y&list=PLrmQ9R9YkZmuH2HQBVQFH1CU-YHZeKW06https://www.youtu...

 

Please mark my reply as Helpful and/or Accept Solution, if applicable. Thanks!

 

I invite you to checkout  below  items for more interesting and knowledgeful ServiceNow stuff.

ServiceNow Index - Meaning, Use & Demo | ServiceNow Indexing Demo | Indexes In ServiceNow ServiceNow Indexing Enjoy the exclusive content - ServiceNow Basics Tutorials: https://www.youtube.com/playlist?list=PLrmQ9R9YkZmvGlU6zRVvtwQVndoXkvP0O ServiceNow Tips & tricks: ...