Parent data from oracle and child data from ES

hi , i am building simple application with one to many relationship type of
loading . i read parent data from oracle and child data from ES (Since Es
is bit fast ) and merge this into a single document. so now my problem is
reading the data from ES in optimized way . Currently i am searching by
match query QueryBuilders.matchQuery("
fieldName1", "0000000") . its taking 85 secs to retrieve 148371
documents . is there any better way to this . like grouping or indexing
with fieldName1 .
Java:-
Is there any way to load full index into my heap one time and get the
document from it because my index is small 70mb .
is there any way to build parent child one to many relation between two
separate index.

. Please do the needful Thank You in Advance

--
You received this message because you are subscribed to the Google Groups "elasticsearch" group.
To unsubscribe from this group and stop receiving emails from it, send an email to elasticsearch+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/elasticsearch/9aaa1109-95c1-4b1a-ac62-2c31df354928%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.