Manage List and Library – Part 1


Indexed Columns

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)
  • Number
  • Currency
  • Date and Time
  • Lookup (single value)
  • Person or Group (single value)
  • Yes/No
  • 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

1

2. Click on Indexed columns in the page ( this is after the listing of columns for that particular list)

2

 

3. You can see the below wordings mentioned clearly. Click on Create a new index link3

4. There are two indices you can choose at one go. Primary column and Secondary Column. Go ahead and choose whichever column you want to index4 5

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.6

 

 

 

 

 

 

 

 

Advertisements

About gai3kannan

I am working with NCS Pte Ltd as a Lead Consultant I have taken SharePoint as my full time action and thoughts.
This entry was posted in My Own Posts, SharePoint 2010, SharePoint 2013 and tagged . Bookmark the permalink.

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s