I would like someone to confirm an issue about how our indexes are structured.
We have and Index with all the documents of a type that counts 20M docs. Of these, only 6M have an isActive=true field and are used in aggregations/sorting/. 14M are mainly accessed by id, sometimes using term/match searches.
We have an alias with a filter to work only on these 6M companies.
The question is: is ElasticSearch loading fielddata for all 20M docs? Would it be better to have 2 different indexes (active/inactive) and an alias "full"?