Learn how to add indexes to SharePoint list and library columns to make sorts, searches, and filtering more efficient and perform better.

Learn about solutions for List View Threshold limit for all SharePoint versions, including using indexes and filtered views, editing the list view, using folders, sync and offline date, using …

Learn how to create relationships between lists by using a combination lookup columns and relationship enforcement (cascade and restrict delete) to preserve the integrity of your data; …

This article discusses default types of columns that you can create and when to use each type of column. Columns are added to one or more views of the list or library to help you display the …

Filtered views with column indexes (and other operations) create database queries that identify a subset of columns and rows and return this subset to your computer.

Learn how to set up metadata navigation for an entire list or library. Users can use a navigation tree to filter a list, and find what they want more easily

Dec 31, 2016 · If you have a large number of list items (exceeding the List View Threshold of 5000 items), you can index existing columns to increase filtering performance. For more …

When you design a Microsoft Office InfoPath form template, you can choose whether to display the data that users enter into specific fields in the form as columns in the default view of a …

You can create a Managed Metadata column that maps to an existing term set or term at any level on a site (for example, as a site column, or as a column local to a specific list or library).

Using formulas in calculated columns in lists can help add to existing columns, such as calculating sales tax on a price. These can be combined to programmatically validate data.