I’ve a requirement to search on multiple index (Inventory and Product) at the same time and combine result.
Is there a way to search on multiple index and combine result in the same way as join (Left / Inner)?
More background of my project.
“Product” index will have 10 Million plus records
and “Inventory” index will have about 5-6 Million records.
“Product” index will be updated a few time per day.
“Inventory” index will be updated a lot more often.
Is it a good idea to combine “Product” and “Inventory” into one index and use distinct?