How to create an index

 

How to create an index

1. Go to the list that you want to set an index for.
2. On the List tab, click List Settings.
3. Under Columns, click Indexed columns.
4. Click Create a new index.
5. Under Primary column for this index, select a column that you will frequently filter or sort on.
6. Click Create.
   Note: If you get an error preventing you from creating the index, you may need your administrator to create the index for you. Or, you may need to create the index during the Daily Time Window for Large Queries.

How to enable the Daily Time Window for Large Queries

In Central Administration, click Application Management on the left.

Click Manage web applications.

Select the web application that contains the large list.

Click General Settings, and then click Resource Throttling.

Under Daily Time Window for Large Queries, click to select Enable a daily time window for large queries.

Set a start time and duration when most of your users will not be working.

Click OK.

Creating indices, key filters, or moving items in a large list

If your list has more than 5,000 items, errors may prevent you from creating indices, key filters, or moving items. However, one or more of following will solve this problem:

• Do these tasks during the Daily Time Window for Large Queries. Your administrator can establish this time window. Refer them to the section above entitled, “How to enable the Daily Time Window for Large Queries.”
• Ask your administrator to create indices, key filters, or move items for you.
• Obtain permissions that will allow you to create indices, key filters, and move items without errors and warnings. This essentially means becoming a member of the Administrators group in Windows Server. Note: This is often impractical at large organizations.

 

Tags van Technorati: Lists,Query,Throttling,Index