Tutorial on Handling Large Lists

This tutorial is really really cool. It talks about the various options we have to handle large lists in SharePoint 2010.

http://office.microsoft.com/en-us/sharepoint-server-help/sharepoint-lists-v-techniques-for-managing-large-lists-RZ101874361.aspx

In summary, we can make use of  folders, views, column indexing and Key Filters (metadata based filters) to manipulate large lists.

Additionally we can also use Excel, Access or SharePoint WorkSpace to take the large lists offline to manipulate it.