Hi jimtronic, I think you have the answers I need. I have several questions.
As a rough example, when you create your view, if you have one parent record and three child records, do you end up with three denormalized records or one record that has data for three child records consolidated into each child field? To illustrate, if you start with two tables that look like this: <http://lucene.472066.n3.nabble.com/file/n4011006/tables.jpg> does your view look like this: <http://lucene.472066.n3.nabble.com/file/n4011006/denormalized.jpg> or this: <http://lucene.472066.n3.nabble.com/file/n4011006/consolidated_fields.jpg> Biff -- View this message in context: http://lucene.472066.n3.nabble.com/need-best-solution-for-indexing-and-searching-multiple-related-database-tables-tp4009857p4011006.html Sent from the Solr - User mailing list archive at Nabble.com.
