This is a good place to use a filter query as well, especially if you want results from any combination of the tables
> On Apr 10, 2022, at 5:05 PM, Saurabh Sharma <saurabh.infoe...@gmail.com> > wrote: > > In case you are having very less data in tables then you should index all > four tables in a single core. With every document you can index table > identifier and during query you can use that identifier . > > > //For table person > { > 'name':'neha' > 'type':'person' > } > > //For table department > { > 'name':'information technology' > 'type':'department' > } > > //For sport table > { > 'name':'cricket' > 'type':'sport' > } > > all these docs have name field but can be distinguished on the basis of > type field . > > > Thanks & Regards > Saurabh > > >> On Mon, Apr 11, 2022, 2:02 AM Neha Gupta <neha.gu...@uni-jena.de> wrote: >> >> Dear Solr Community, >> >> Need your advice for the best option >> >> I have four tables in the DB and i want to index them in Solr. >> >> I want to query these tables differently in Solr as they don't have any >> relation between them. Could you please tell whether i should create >> different cores for each table or should i indexed them in one core with >> different entities. If latter is the case then how i can query Solr on >> basis of entity? >> >> >> Thanks and Regards >> Neha Gupta >> >>