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