Multiple index from the same database
I want to create multiple indexes. The columns for both the indexes are same. Each index fetches data from the same database but different schemas.
I could have configured a single index with a union query from both the schemas, but I just want to avoid this.
Your document says that I should not configure two indexes for the same databse else the increamental indexing will run into each other and later job will abort the previous indexing job.
Is it still a limitation?
What if I use two different users in the the configured datasource for each index?
What is the best solution?