Forum Discussion
Single Index vs. Secondary Column Index | Index strategy over 5000 items
I have many lists that are migrating breaking the magic 5000 items list view threshold. Fun stuff. I am unable to add indexes to the lists as it says the item limit is to high. Feels like a catc...
My two cents here:
1. Assuming you are talking about SPO, the only alternative I can think to create such indexes is buy using CSOM but you will probably have the same problems.
2. Indexes are good for views, but can penalize the performance when doing CRUD operations
3. You have to view this such as creating indexes in SQL Tables
1. Assuming you are talking about SPO, the only alternative I can think to create such indexes is buy using CSOM but you will probably have the same problems.
2. Indexes are good for views, but can penalize the performance when doing CRUD operations
3. You have to view this such as creating indexes in SQL Tables
Yep and CSOM won't work in this case as it already exceeded the 5000 items limit.