This issue is related to EsRelation, EsSourceExec, EsQueryExec.

Each of this classes contains following fields:

    private final IndexMode indexMode;
    private final Map<String, IndexMode> indexNameWithModes;

indexMode is set from UnresolvedRelation and contains predicted index mode.
indexNameWithModes contains actual resolved index modes for every backing index. This map might be fairly large (when using alias or index pattern that points to hundreds or possibly thousands of indices).

This issue is about reviewing those field usages in order to:

• check if it is possible to replace indexMode with actual values from indexNameWithModes
• check if we always need the entire indexNameWithModes or it too could be replaced with a smaller subset of information.

Related to: #112998