because there will be billions of records in my db
when I search for one father's children data I don't want Elastic will waste its time when searching among all the data that most of it is clearly not relevant.
generally, each query interested only in part of father's children's data or all of it.
if so, I can lead Elastic to search only in one index that has the relevant data (dozen of thousands of record instead of billions of records).
after what I said above, do u think I need one index?
for now, with one father in my elastic data, on one server I can see that I get elastic search results (520000 records when each record have 40 fields) in one minute or more.
it is not fast enough:(
so you think that in my case Oracle will be better when will do benchmarking?