SPO Tidbit – Predictive Indexing and what does that mean


Hello All,

This feature has been rolled out to all production tenants, on the road map the feature description is:

Over the coming months, we will be phasing in automatic indexing and performance optimization to improve performance of large lists and reduce or eliminate problems in large scale lists.

But what does that really mean?

As you may know the current item limit for a list is 30 Million this is a massive number and to work better with large datasets like that you would want to use indexes, in comes Predictive Indexing to automatically create those indexes based on views without user intervention allowing you to focus on the experience and not the technicalities under the hood.

The rules for this are the following:

  1. Available in Modern UI only
  2. Works when item is between 2,500 – 19,999 items
  3. Created when you sort a list or filter a view
  4. Only works with the following column types (The column that you sort)
    1. Single line or Multiple line of text
    2. Date/Time
    3. Single or Multiple Value
    4. Number
    5. Currency

 Well this is all great but what does that do for the end user?  And the end result is that while you still have List/Library thresholds of 5,000 we can now view large lists without filtering or getting blocked by throttling, because we will use the index (By default on modified date column) to improve performance on viewability.

You can see the ignite presentation of this here (Note: at 42:31 is when they talk about this feature, although the whole video is awesome)

Pax

Comments (2)

  1. Dean Gross says:

    I am having some problems with this functionality. My customer has several libraries with a few thousand items and the automatically generated index for the Modified column does not exist. I have run some tests in other sites and it is not getting created, how long should it take after files have been loaded and sorts performed? I have ticket opened with MS Support and they referred me to this article.

    1. Hello Dean,

      Honestly not sure how long it takes as it was never something we focused on when testing it with my customers, but I would suggest you make sure that you have the following covered off as they will all prevent the feature from working
      1. Available in Modern UI only
      2. Works when item is between 2,500 – 19,999 items
      3. Created when you sort a list or filter a view
      4. Only works with the following column types (The column that you sort)
      Single line or Multiple line of text
      Date/Time
      Single or Multiple Value
      Number
      Currency
      I know not quite answering your question, but hopefully it gives you somewhere to focus.

Skip to main content