I don't see how join would help me I don't really have parent/child relationship, the only common field is product_id
For example, for different sheos of same model, img and title is different for each model : [ {"product_id":1, "offer_id":1,"title":"Converse all star - red - 8", "attribute_size":"8", "attribute_color":"red", "price":49}, {"product_id":1, "offer_id":2,"title":"Converse all star - red - 9", "attribute_size":"9", "attribute_color":"red", "price":49}, {"product_id":1, "offer_id":3,"title":"Converse all star - blue - 8", "attribute_size":"8", "attribute_color":"blue", "price":49}, {"product_id":1, "offer_id":4,"title":"Converse all star - blue - 9", "attribute_size":"9", "attribute_color":"blue", "price":49} ] How can i index/query for using join in order to have only one shoe per model (the best price for example)? -- View this message in context: http://lucene.472066.n3.nabble.com/Field-collapsing-bad-performances-schema-redesign-tp4038359p4038500.html Sent from the Solr - User mailing list archive at Nabble.com.