For lists and libraries with large numbers of items, users can access the items with a mix of views and search. The following are some suggestions for views that work well with an indexed column:
Recently changed To create a view of only the items that have changed in the past week, you can index the Modified column and then apply the filter Modified (Indexed)is greater than[Today]-7.
New items To create a view of only those items that were added in the past week, you can index the Created column and then apply the filter Createdis greater than[Today]-7.
My items To create a view of only those items that you added, you can index the Created By column and then apply the filter Created Byis equal to[Me] .
Due today For lists or libraries with a Due Date column, you can index that column and then apply the filter Due Dateis equal to[Today] .
Discussion board updates To create a view of only the discussions that were updated in the past month, you can index the Last Updated column on a discussion board, create a new Subject view, and then apply the filter Last Updatedis greater than[Today]-30.