We can create index columns to help the performance improve to some extent. But indexing also has its own limitations. We can index only 20 columns in a list. Indexing a column means the same as it would mean in any SQL table. It is to allow us to find the values quickly and this is needed when there happens to be more than the allowed threshold.
It is always advisable to index columns which will have unique values – column ID in almost all the list has unique values.
The following data types alone can be indexed and rest all data types are not supported:
- Single line of text
- Choice (single value)
- Date and Time
- Lookup (single value)
- Person or Group (single value)
- Managed Metadata
How to create a simple or compound index?
1. Browse to the site and the list where you want to index the columns. Click on List Settings from the menu ribbon
2. Click on Indexed columns in the page ( this is after the listing of columns for that particular list)
5. Once you select and click on create, you will get to the page which says the number of indices you had created. Choose wisely and create index for all those fields which you might be looking into quite often.