Is it possible to display the most recent 5,000 items in a list using the ID ? If the answer is yes, then how ? Also, is the ID inherently have an index ?
I noticed when I tried to create an Index on ID it was not an available field.
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It only takes a minute to sign up.Sign up to join this community
5000 is the list item limit for a view, or as Microsoft puts it, "approximately 5000". (Source) So in theory the number is achievable.
ID has an incremental number as its value, but it is not available as a column to be shown. If you want to use it, you may achieve it by creating a calculated column which uses the value of
[ID]. Bear in mind, that when a list item is removed, its index value becomes empty.
You may want to make a view that shows items sorted by Created or Modified date to see the recent items in the list according to that. I wouldn't rely on ID's alone because they increase as time goes by but don't get replaced or re-used when users delete items in the list.
According to this the built in ID column is already indexed as it is a system field(column). https://msdn.microsoft.com/en-us/library/ff798465.aspx