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
>> 
>> 

Reply via email to