Jean Paul's Blog

There are 2 types of People in the World, One who Likes SharePoint and..

  • Microsoft MVP

  • MindCracker MVP

  • CodeProject MVP

  • eBook on SharePoint 2010

  • eBook on Design Patterns

  • eBook on Windows Azure

  • NLayers Framework @ CodePlex

  • MSDN Forums

  • .Net vs. Java

    Due to Public Demand

Posts Tagged ‘indexed columns’

Indexed Columns to Improve List Performance

Posted by Jean Paul on May 20, 2015

In this article we can explore Indexed Columns which is a less-used feature in SharePoint.

Indexed Columns

Indexed Columns allows Indexing of List or Library columns. This enable the following advantages:

1. Increase speed of data retrieval

2. Improve Performance of large list or library

Indexing at list or library level will be applied to the database tables too. This helps in increasing retrieval speed especially used for the WHERE condition fields.

Improving Performance is required when the list view threshold has reached, for example a list with more than 5000 items.

Create Indexed Columns

To create indexed columns for a list or library do the following steps.

Open the List Settings Page.


Scroll down and click on the Indexed Columns link.


You will get the following page.


Click on the Create a new index link. You will get the following page.



Please note that SharePoint does not allow all column-types to be indexed. See references section for more information.

You can choose the column for indexing. For the time being, I have chosen Content Type.


The changes will be saved automatically.


You can add up to 20 indexed columns.

Database Index

If you have examined SharePoint Content Database Table structure, you will be knowing that SharePoint stores a record in multiple rows in the AllItems table. This table also contains record (items) from different lists. So you might have the concern:

Adding an Index can impact other List items too!

Explanation: This case won’t happen as once a column is indexed, the data will be stored in a new table. So whenever we are adding indexed-columns, a new database-column creation happens in the background. The new database-column will be indexed and thus provides better performance.



In this article we have explored Indexed Columns.

Posted in SharePoint, SharePoint 2013 | Tagged: , , | Leave a Comment »