UseCase:
Assume that i pushed resident data into Azure Search, with City field as searchable and resident name field as retrievable.
If i just search on City, can Azure search return all records.
Lets assume i have close to 10M records per city.
Bottom line is am trying to understand the retrieval limitation for Azure Search.
Note: I know i can use Databricks/Spark or equivalent solutions to query directly from DB, but this question is purely on Azure search standpoint.