Indexed columns to make your very large lists and libraries run faster

This helps with getting over the 2,000 limit in a library but can see how it could be useful for lists with 500 plus items as well.....

* There are other tuning techniques that can speed up your sharepoint. Mainly database related.

You can set up indexed columns on a list or document library in Windows SharePoint Services 3.0 or in Microsoft Office SharePoint Server 2007...

Evry list item that has an indexed column will create a new row in the NameValuePair table.(The “NameValuePair_Latin1_General_CI_AS” table for the English Language version of SharePoint)
The table also needs to be updated whenever indexed columns change their value or when items are added or deleted. E.g. Having a list with 100,00 items and an index column for instance means that you also add 100,00 items to the NameValuePair table.
And - every time you update your list - NameValuePair need to be updated as well.

Tom Bizannes works for MacroView Business Technology who specialise in Solutions in Microsoft Office and SharePoint.
http://www.macroview.com.au