SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

My organization is in the process of migrating to SharePoint 2010, and some of our larger lists (15,000+ records) are now being throttled.

I've read up on this and understand that I need to limit my views/queries to only return < 5,000 records, and to make it so my queries don't have to actually process > 5,000 records, I should be creating indices.

However, when I try to create an index on the large list, I receive the following message:

SharePoint 2010 - error when creating index on large list

I'm aware that the ability to create indices on large lists is restricted because it has to access all of the items in the list. What's the best way to get around this restriction?

My farm administrator has informed me that "There is no farm level restriction that would prevent site collection administrators from creating indices on a list," so what do I do?

share|improve this question
up vote 3 down vote accepted

Read this :

Also :

Hope it helps

share|improve this answer
So it seems like the daily time window can help me, assuming my administrator enables this feature. Thank you! – Pandincus Jun 2 '11 at 14:22

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.