Column Indexing
*Name Value Pair (NVP) Index
*Pro tvorbu pohledů nad velkým počtem položek
Např. Všechny dokumenty splňující podmínku Due Date = TODAY
*V SQL Serveru se vytváří tabulka pro tento index
*V dotazech se používá pouze jeden index
Instructor Notes
List and document libraries faced performance limitations in WSS V2 when their contents exceeded 2000 items of documents. While nothing could really be done to help large lists perform better, documents within a Document library could be partitioned into folders of 2000 documents or less.

The column indexing scheme introduced in WSS V3 allows you to optimize performance on large document libraries without resorting to folder-based bucketing scheme. It's also a very welcome feature for optimizing item retreival for large lists which didn't support any suitable optimization technique in WSS V2.