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