Improper behavior of SharePoint List View Threshold with Indexed Columns RRS feed

  • Question

  • Scenario : 

    We are working on couple of Large Lists in our SharePoint 2013 Foundation (On Premise) Project.

    List View Threshold has been set to 5,000 only to prevent any performance degradation issues on the server.

    The total number of items in the Large List are 30,000.

    We need to create views with grouping, sorting, filtering.

    Indexes are already created on the Columns being used in Filtering, Sorting and Grouping as per the Standard suggestions to deal with the Large Lists in SharePoint.

    Issue : 

    Even after following all the required steps and filtering data on the indexed columns (which returns records less than 5,000), the View is still showing error of Threshold. Same happens while Sorting, Grouping Views.

    Solutions Tried :

    Increasing Threshold from Central Admin. (We want to keep List View Threshold to 5000 only)

    Indexing Columns being used in Filtering, Grouping, Sorting. (Only Indexed columns are being used in any such settings)

    Friday, January 27, 2017 12:25 PM

All replies