Search multiple indexes at once
The underlying elasticsearch technology supports making a single search query that searches and ranks results over multiple disparate indexes at once, but this functionality is not surfaced through the Azure Search APIs.
Adding this would allow a single search to span over indexes with different schemas combined in a single correctly ordered result set.
Thank you for your feedback. We could support search across indexes in the same search service. Across different search services would be much harder. We’re considering this for a future release of Azure Search.
Azure Search Product Team
I found a workaround... You can create a view on two or more tables (respective, indexes) .... In azure sql database, views are simple queries... It will update itself when respective tables get updated... Add "High Water Mark Change Detection policy" on the last_updated column for data source....
That would be a great start. alternatively, support use of dico based on a field, so different synonym dictionnary can be applied to different rows, would be good.
I vote for that, that is really an extremely good capability, I saw it is supported by Elastic Search https://www.elastic.co/guide/en/elasticsearch/reference/current/multi-index.html
Denis Ouspenski commented
Much needed functionality, especially for simplicity of use with paging.
Cody Pain commented
How do we add this?