SharePoint List Automatic Indexing

%3CLINGO-SUB%20id%3D%22lingo-sub-1051256%22%20slang%3D%22en-US%22%3ESharePoint%20List%20Automatic%20Indexing%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1051256%22%20slang%3D%22en-US%22%3E%3CP%3EIn%20this%20%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fclient%2Fmanage-large-lists-and-libraries-in-sharepoint-b8588dae-9387-48c2-9248-c24122f07c59%3FNS%3DSPOSTANDARD%26amp%3BVersion%3D16%26amp%3BAppVer%3DSPO160%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Earticle%3C%2FA%3E%26nbsp%3B%20there%20is%20the%20following%20Note%3A%20Automatic%20index%20creation%20when%20sorting%20in%20the%20modern%20experience%20is%20limited%20to%20lists%20and%20libraries%20with%20less%20than%2020%2C000%20items.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20expecting%20to%20have%20about%2015000%20items%20(rows)%20in%20a%20list.%26nbsp%3B%3C%2FP%3E%3CP%3EDo%20I%20need%20to%20create%20indexes%20for%20column%20manually%20or%20that%20Automatic%20indexing%20does%20it%20for%20me%3F%3C%2FP%3E%3CP%3EMy%20concern%20is%205000%20items%20limitation%20in%20a%20list%20view.%3C%2FP%3E%3CP%3EAnd%20do%20I%20need%20to%20run%20%22Reindex%20List%22%20periodically%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20in%20advance.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1051256%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ELists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1053436%22%20slang%3D%22en-US%22%3ERe%3A%20SharePoint%20List%20Automatic%20Indexing%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1053436%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20imported%20an%20excel%20file%20with%2012000%20items%20into%20the%20Sharepoint%20List.%20The%20default%20view%20is%20All%20Items%20and%20I%20have%20not%20got%20any%205000%20Threshold%20Errors%2C%20though.%20Probably%20this%20is%20because%20I%20didn't%20scroll%20(by%2030%20items%20in%20a%20batch)%20to%20the%20bottom.%3C%2FP%3E%3CP%3EThe%20Automatic%20Indexing%20creates%20the%20first%20index%20and%20all%20subsequent%20indexes%20are%20created%20after%20sorting%20any%20columns%20(besides%20those%20that%20are%20not%20supported).%20So%20it%20is%20not%20necessary%20to%20create%20them%20manually.%3C%2FP%3E%3CP%3EBut%26nbsp%3B%20%3CSTRONG%3EList%20view%20threshold%3A%2011282%20items%20(list%20view%20threshold%20is%205000)%20%3C%2FSTRONG%3Eis%20still%20there%20(in%20the%20list%20settings).%3C%2FP%3E%3CP%3EAfter%20some%20googling%2C%20I%20have%20found%20%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Fuse-filtering-to-modify-a-sharepoint-view-3d8efc52-0808-4731-8f9b-3dfaeacea3d4%22%20target%3D%22_self%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ethis%20article%3C%2FA%3E%20it%20helped%20me%20to%20realize%26nbsp%3B%20how%20ridiculous%20this%205000%20throttle%20is.%20If%20I%20understand%20it%20correctly%2C%20to%20work%20with%20lists%20longer%20than%205000%20items%2C%20I%20need%20to%20create%20separate%20views%20based%20on%20some%20filtering%2C%20but%20how%20am%20I%20supposed%20to%20know%20that%20that%20filter%20will%20return%20less%20than%205000%20items%3F%20Microsoft%20proudly%20inform%20their%20users%20of%2030%20millions%20list%26nbsp%3B%20items%20limit%20...%3C%2FP%3E%3CP%3EHaving%20Excel%20files%20on%20Sharepoint%20online%20to%20mitigate%20this%20issue%20is%20not%20an%20option%20for%20me.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Contributor

In this article  there is the following Note: Automatic index creation when sorting in the modern experience is limited to lists and libraries with less than 20,000 items.

 

I am expecting to have about 15000 items (rows) in a list. 

Do I need to create indexes for column manually or that Automatic indexing does it for me?

My concern is 5000 items limitation in a list view.

And do I need to run "Reindex List" periodically?

 

Thank you in advance.

1 Reply
Highlighted

I have imported an excel file with 12000 items into the Sharepoint List. The default view is All Items and I have not got any 5000 Threshold Errors, though. Probably this is because I didn't scroll (by 30 items in a batch) to the bottom.

The Automatic Indexing creates the first index and all subsequent indexes are created after sorting any columns (besides those that are not supported). So it is not necessary to create them manually.

But  List view threshold: 11282 items (list view threshold is 5000) is still there (in the list settings).

After some googling, I have found this article it helped me to realize  how ridiculous this 5000 throttle is. If I understand it correctly, to work with lists longer than 5000 items, I need to create separate views based on some filtering, but how am I supposed to know that that filter will return less than 5000 items? Microsoft proudly inform their users of 30 millions list  items limit ...

Having Excel files on Sharepoint online to mitigate this issue is not an option for me.