To improve the performance of a large list or library, you can index a column. Then you can use the indexed column to filter new or existing views of the list or library.
Note Each additional column index consumes extra resources in the database. Therefore, you should add indexes only to columns that will be used actively in views on the list or library.
- If the list or library is not already open, click its name on the Quick Launch.
If the name of your list or library does not appear, click View All Site Content, and then click the name of your list or library.
- On the Settings menu , click List Settings, or click the settings for the type of library that you are opening.
For example, in a document library, click Document Library Settings.
- Under Columns, click Indexed columns.
- Select the check box next to each column that you want to index.
- Click OK.