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 once1, 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
Is there any update on this?
I see a comment that cross-index query can be supported within a single service. But it doesn't look like there is a movement
Is there any update on this functionality? it will be a great addition for the enterprise search platform.
Is there any update?
Is there any update ?
Microsoft, do you have an update on this review please? It’s been more than a year. Thanks
Is there any documentation to search multiple indexes in the same search service.
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?