As we know that SharePoint store List information
and its item in SQL Server and SharePoint DB is not purely R-DBMS. So by using
index in SharePoint List we can improve the performance.
Here in this article I am going to explain
how we can create a new index on a LIST.
Step
1: Open your Share Point web site.
Step
2: Select List on which you want to create
index.
Step
3:
Select LIST -> List Settings

Image 1.
Step 4: Select Indexed Columns.

Image 2.
Step 5: Select Create a new index.

Image 3.
Step
6: Select column on which you want to make
index

Image 4.
Now you can see you index column. . .

Image 5.