I have the following scenario inside our sharepoint online and sharepoint on-premises 2013:-
2) Now when i go to the Wiki Pages library >> Add Indexes >> i were not able to add indexes for any of the managed metadata which allow multiple values, and seems sharepoint does not support indexing managed metadata column which allow multiple values. so currently we only have these indexes:-
3) I have enabled the metadata navigation for the wiki pages list and i added the managed metadata fields to them.
Now i have the following 6 questions:-
1- our wiki pages library is reaching 3,000 wiki pages, and the threshold inside our SP on-premises 2013 is set to 5,000. so i think when the wiki pages exceeds the 5,000, the main list view which is showing all the wiki pages sorted by modified date will stop working,, is this correct? or since i am sorting based on the "Modified date" which is indexed then my main view will work well and will be able to show all the wiki pages ?
2- Now we depend a lot on the "Metadata Navigation" filtering a lot, but since the "Metadata Navigation" contain 6 managed metadata columns which can not be indexed, so does this mean that if the wiki page list exceed the 5,000 items, then the ability to do a metadata navigation will not work? and what will be the workarounds?
3- Now inside sharepoint on-premises we can increase the threshold limit for the web application from 5,000 to let say 8,000 and we can live happily for the next couple of years, as we had 3,000 wiki pages in almost 3 years. but now we are planning to migrate our enterprise wiki site collection to office 365, and inside office 365 we will not have any option to increase the list view threshold, nor office 365 allow indexing managed metadata columns which allow multiple values.. so what are the options we have to manage this enterprise wiki site collection inside office 365 incase the wiki pages exceed the 5,000 threshold?
4- generally speaking, there is an unclear point about indexing. for example in our case we add an index to the "Modified" date field, and our main list view which show all the items, sort items based on the "Modified" data descending + it does not have any filtering, so which of the below situations we will face if the main list view exceeds the threshold:-
since the list view is been sorted based on an indexed column"modified", so the list view will show all the wiki pages (5,000 +++)?
or sharepoint will only show the latest 5,000 wiki pages?
or will show an error?
5- let say i add a filter to the list view such as ("Modified date" > [Now]-365) , to show only the wiki pages which have been modified in the past 365 days. so which situation we will face if the main list view exceeds the threshold:-
Sharepoint will show all the wiki pages which satisfy the filtering, even if the result exceed the threshold.
Sharepoint will show an error if the wiki pages which satisfy the filtering criteria exceed the threshold.
or Sharepoint will only show the latest 5,000 wiki pages which satisfy the criteria?
6- last question. in sharepoint online is there any plans for Microsoft to exceed the 5,000 list view threshold? or to allow us to have the options to exceed it manually (as in the on-premises cases) ? or can we do an assumption that sharepoint online will not have any threshold limits in the future?
Thanks in advance for any help on the above 6 questions.