Currently the name of an index in the database doesn't suggest which table does the index belong to.
The Service Builder creates an index-sql and all the index_names start with IX_<number>. In case issues occur related to an index as well it is very difficult to analyze which index is missing or invisible.
IX_23745345 - has no information
IX_TableXY_column2_column5 - has the information which table and columns are involved
It would be beneficial if the 'finder' of a service entity could have a parameter, e.g. index-name, which allows to specify the index name, like in the following example :
<finder name="Group_Template" return-type="Collection" index-name="TableXY_column2_column5">
<finder-column name="column2" />
<finder-column name="column5" />
The parameter could be optional, keeping the current behavior if not set.