Time for action – editing an Index

We want to enhance the TotalOrdersPerCustomer index by adding a Reduce function. For that, we will open the index in the Edit Index screen and modify its related LINQ functions.

1. In the Management Studio, display the Indexes screen.

2. Click on the pencil at the right of the name of the TotalOrdersPerCustomer index.

3. In the Edit Index screen, click on the Add Reduce button to add a new Reduce function

4. In the Reduce section, enter the following code snippet:

   from result in results
   group result by result.CustomerId into g
   select new {CustomerId = g.Key, TotalCost = g.Sum(x=>x.TotalCost)}

5. Click on the Save Index button to save changes.

6. Click on the Indexes links to show the Indexes list.

7. Click on the TotalOrdersPerCustomer index to query it and display results in the Query Index Screen.

   

What just happened?

We enhanced the TotalOrdersPerCustomer index and added a Reduce function.

This Reduce LINQ function aggregates the result of the Map function (written in the previous...