PowerShell™ for SharePoint® 2013 How-To

Configure the Maximum Order By Clauses

Scenario/Problem: You need to modify the maximum amount of Order By clauses in a query.

Solution: Use the OrderByMax parameter with the Set-SPAccessService Application cmdlet.

The OrderByMax parameter has a default value of 4 and determines the maximum number of Order By clauses that can be contained within a query. The valid range of values for this parameter is 0 to 8. Listing 23.5 shows a sample modification of the maximum number of Order By clauses.

Listing 23.5. Changing the Maximum Number of Order By Clauses

Set-SPAccessServiceApplication -Identity "Access Services"-OrderByMax 2

Order By clauses instantiate sorting algorithms within the query engine. Although this can be optimized with indexes, ...