Foremost, I am not an administrator of SharePoint site and have very limited controls on my page. Earlier, I had created a list (custom list with Datasheet view). I had created over 20 views (one for each country) on this list. The list had exceeded 5000 records. So, I had indexed the list against the country code (based on which the views were filtered). It was working fine, even for those countries / views that had over 3000 records.
Recently, I had to delete and re-load the records for some reason. The number of records did not change much, but now, the views with over 1000 records are throwing list view threshold exceeded error.
For delete and load, I did the following: - I have deleted records through front-end and cleared them from Recycle Bin. Then, I copied contents from excel sheet and pasted into datasheet view. - On seeing error, I cleared off contents from list again and tried to push records from MS Access linked table using an Access SQL query. Error comes back promptly after this type of loading too.
Am I missing something here? How was it working earlier? Why is it not working now? Please help.
EDIT: I found something interesting today. Actually, there are three tables, and their behaviors are quite different - and definitely, not consistent. Please refer to the attached image that does the comparison
I am, I am missing out something here. I am banking on your expert opinions