I have one list i.e-Tickets which is having more then 300K records. There are more than 10 views, now no one view showing items but it is giving threshold limit warning. Threshold limit we set as 80K.
Only ID column is indexed in this list which is by default, now i want to show last 5000 items which is obviously based on the ID column. I checked, list view only shows items if filter expression uses ID column.