Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

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
add comment

1 Answer 1

up vote 3 down vote accepted

Read this : http://blogs.msdn.com/b/dinaayoub/archive/2010/04/22/sharepoint-2010-how-to-change-the-list-view-threshold.aspx

Also : http://technet.microsoft.com/en-us/library/cc262813.aspx

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
add comment

Your Answer

 
discard

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.