I have a large SharePoint list with around 2.5++ million items >> and I defined to only get the items with Status = "Active" and order the items by Modified data in descending order, as follows:
And I defined the Pagination of 100,000 items, as follows:
So how the Get Items will work internally in this case? Will it only search the first 100,000 items (order by Modified desc) and get the ones with status = "Active"? or it will be able to search the 2.5 items, and get the related ones with Status = "Active" + Order by "Modified desc"?