Query optimization for the Link SAT with Dependent Child

[saqib]

@patrickcuba , see here:

Modeling a dependent child

Saqib, you are correct. This appears to be a dependent child and is used to maintain the unit of work of the transaction represented in the link. You are correct in modeling it as such. Just make sure that it is included in your link hash string. The caveat here is that manufacturer is not a business concept, that it meets the litmus test of a dependent child key (manufacturer id) (i.e., cannot stand alone and have meaning without the context of the relationship). If this is truly the situ…

per @cmeyersohn , the dependent child(ren) should be part of the LINK HASHKEY generation.