Let’s say, I have 2 tables in Azure SQL – Employee & Address and both the tables have common field, say Address Id.
If I create separate indexes for tables, can I search the data in both indexes from single search API? Is it possible to join 2 indexes? Just cross checking if such functionality exists.
Another option I am aware of is – load data from both the tables to single index using solution given in below. Is this possible only via .NET API? Can we develop it from Portal?
Any other recommended approach?